I have written 3 blogposts about query parameters in the past. Power BI Desktop Query Parameters, Part 1, Introduction Power BI Desktop Query Parameters, Part2, Dynamic Data Masking and Query Parameters Power BI Desktop Query Parameters, Part 3, List Output This is the fourth one in the form of Quick Tips. Here is the scenario. … Continue reading Quick Tips, Power BI Desktop, Query Parameters, Part 4, Passing Power Query Parameter Values to SQL Server Stored Procedures
In the previous posts, here and here, I explained how you can use Power BI Desktop Query Parameters for many different use cases. Power BI development team added another cool feature to Power BI Desktop on July 2016 which is the ability to add a List Query output to a query parameter as it’s “Suggested … Continue reading Power BI Desktop Query Parameters, Part 3, List Output
As I promised in my earlier post, in this article I show you how to leverage your Power BI Desktop model using Query Parameters on top of SQL Server 2016 Dynamic Data Masking (DDM). I also explain very briefly how to enable DDM on DimCustomer table from AdventureWorksDW2016CTP3 database. We will then create a Power … Continue reading Power BI Desktop Query Parameters, Part2, Dynamic Data Masking and Query Parameters
One of the coolest features added to the April 2016 release of Power BI Desktop is “Query Parameters”. With Query Parameters we can now create parameters in Power BI Desktop and use them in various cases. For instance, we can now define a query referencing a parameter to retrieve different datasets. Or we can reference … Continue reading Power BI Desktop Query Parameters, Part 1, Introduction
