Power Query is a powerful tool within the Microsoft Fabric environment, enabling users to manage data sources and transform data efficiently. However, a common issue you may face is that after publishing the Semantic Model, the Power Query parameters either do not appear or are greyed out, making them non-editable. In this post and its … Continue reading Microsoft Fabric: Troubleshooting Query Parameters in Published Semantic Models
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
