What we are working on at SQLBI

No, this is not the end-of-the-year blog post about what happened in 2024: There is still more than one month to go! However, we are receiving many requests asking what we are working on at SQLBI. I wanted to write…  Read more

SQL database in Fabric

In the mass of announcements made at Microsoft Ignite, I want to mention the SQL database in Fabric, which finally closes a gap we had in Power BI for many years. In May 2022, Microsoft launched Power BI Datamarts in…  Read more

DAX Patterns

Parameter table

The parameter table pattern is used to create parameters in a report so that users can interact with slicers and dynamically change the behavior of the report itself For example a report can show the top N products by category…  More on DAX Patterns


SQLBI Corp.

Optimizing DAX, Second Edition

Optimizing DAX is the state-of-the-art book on optimizing DAX expressions in Power BI and Analysis Services semantic models.
Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements. Read more