-
Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance and scalability than DirectQuery at the price of a small development cost. Read more
-
This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services. Read more
-
The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. Read more
-
If you try to use SELECTEDVALUE on the visible column of the table generated by the Fields Parameters feature in Power BI, you get the following error: Calculation error in measure ‘Sales'[Selection]: Column [Parameter] is part of composite key, but… Read more
-
This article describes how the SELECTEDVALUE DAX function simplifies the syntax required in many scenarios where you need to read a single value selected in the filter context. Read more
-
This article explains how to use KEEPFILTERS to intersect instead of override an existing filter context in DAX. Using KEEPFILTERS simplifies the code and improves performance. Read more
-
When working on the Mastering Tabular video course, we needed a sample database with more data than what we had at our disposal in existing sample databases. We also wanted to be able to control the content so that different… Read more
-
This article analyzes the fields parameters feature in Power BI, unveiling some of the internals of its implementation. Read more
-
This article is the state-of-the-art guide of the development tools for Power BI and Analysis Services models, providing guidance to improve productivity and access to new features. Read more
-
Did you ever experience a long waiting time while opening a Power BI Desktop file? There could be many reasons for that, but if you have calculated columns and/or calculated tables in your model, you should be aware that they… Read more