Articles of 2021
Development tools for Tabular models in 2021
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
Implementing real-time updates in Power BI using push datasets instead of DirectQuery
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
How to return 0 instead of BLANK in DAX
In this article we show various techniques to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. Read more
Controlling drillthrough in Excel PivotTables connected to Power BI or Analysis Services
This article describes how to customize the drillthrough experience in Excel PivotTables connected to Power BI datasets or Analysis Services databases. Read more
Introducing wholesale and retail execution in composite models
In composite models, any query can be executed on the remote model (wholesale execution) or by mixing local and remote engines together (retail execution). This article describes the differences between the wholesale and retail modes, along with examples. Read more
Different options to model many-to-many relationships in Power BI and Tabular
There are two options to model many-to-many relationships using Tabular and Power BI: you can use either a regular bidirectional filter relationship, or a limited unidirectional relationship. In this article, we compare the performance of both options. Read more
How to enable the Single Value option in a Power BI slicer
This article describes how to enable the Single Value slicer option in Power BI by adding additional metadata to the model with Tabular Editor. Read more
Analyzing the parallelism of storage engine operations in DAX Studio
This article describes the improved server timings features in DAX Studio 2.17 to analyze the parallelism of storage engine operations. Read more
Creating real-time dashboards in Power BI with push datasets
Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined with an Import model already in place. In this article we introduce the architecture of push datasets. Read more
Header/Detail vs Star Schema models in Tabular and Power BI
In this article we perform a performance comparison between header/detail models and star schemas. Building a star schema might require a few ETL steps and some coding. Nonetheless, it is always the best modeling option. Read more