Chicago, IL, USUnderstanding the “can’t determine relationship between the fields” error in Power BI
Marco Russo & Alberto FerrariThis article explains why you might encounter a curious error when placing columns from unrelated tables in a Power BI matrix. Read more
Direct Lake vs Import vs Direct Lake+Import | Fabric semantic models (May 2025)
Marco RussoWhen 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
Jun 24-26 - Amsterdam
Aug 19-21 - Toronto
Oct 1-3 - London
Video Training
Introducing DAX Video CourseFree
Tools in Power BI
Kurt BuhlerThis article gives an overview of some of the available tools that can help you create semantic models and reports. Read more
SQLBI+ updates in April 2025
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
DAX Patterns
Standard time-related calculations
In this pattern we show you how to compute time-related calculations like year-to-date same period last year and percentage growth using a standard calendar The great advantage of working with a standard calendar is that you can rely on several… 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