When I presented “Choosing Between Import Mode, Direct Lake, and Composite Models” at Fabric Conf 2025 in Las Vegas, the room overflowed, and the session was not recorded. I promised to publish the material once the new Direct Lake + Import composite model… Read more
This article gives an overview of some of the available tools that can help you create semantic models and reports. Read more
We released a new course for our SQLBI+ subscribers: Security in Tabular Semantic Models. This course explains how to implement security in Tabular semantic models, considering different requirements, data model design, DAX implementation, and performance. The training is reference material… Read more
How to implement security in Tabular semantic models considering different requirements, data model design, DAX implementation, and performance. Read more
This pattern shows how to compute time-related calculations like year-to-date same period last year and percentage growth using a custom calendar This pattern does not rely on DAX built-in time intelligence functions All the measures refer to the fiscal calendar… More on DAX Patterns
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
Amsterdam, NL
Marco Russo
Kurt Buhler
May 28-30 - Chicago
Aug 19-21 - Toronto
Marco Russo & Alberto Ferrari