Category Archives: Business intelligence
Pushing Data From Excel To Power BI Using Streaming Datasets – Chris Webb’s BI Blog
One Power BI feature that almost passed me by (because it was released in August while I was on holiday) was the ability to create streaming datasets in the Power BI web app and push data to them v…
Πηγή: Pushing Data From Excel To Power BI Using Streaming Datasets – Chris Webb’s BI Blog
Analyzing events with a duration in DAX – SQLBI
Power BI Desktop Query Parameters, Part 3, List Output
Power BI Desktop Query Parameters can be used for many use cases. In this post I show you how to use a list output in Power BI Desktop Query Parameters.
Πηγή: Power BI Desktop Query Parameters, Part 3, List Output
Power BI Desktop Parameters, Part2 Dynamic Data Masking (DDM)
In this post you learn how to implement Dynamic Data Masking (DDM) in SQL Server 2016 and how to user Power BI Desktop Parameters on top of it and much more
Πηγή: Power BI Desktop Parameters, Part2 Dynamic Data Masking (DDM)
Power BI Desktop Query Parameters, Part 1
Combination of rows of tables list in Power Query – Ivan Bond’s blog
Recently I faced interesting Power Query problem. Actually, initial problem has nothing related to Power Query. I required to export quite big volume of data from SAP BW using Business Objects Anal…
Πηγή: Combination of rows of tables list in Power Query – Ivan Bond’s blog
Create Dynamic Periods for Fiscal or Calendar Dates in Power BI – Gilbert Quevauvilliers – BI blog
I came across Chris Webb’s excellent post (Creating Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M) in which he demonstrated how to leverage t…
Πηγή: Create Dynamic Periods for Fiscal or Calendar Dates in Power BI – Gilbert Quevauvilliers – BI blog