Topic: Power BI
-
Should you use RANK or stick with RANKX? In which scenarios is one better than the other? This article provides an in-depth analysis to help readers make informed choices. Read more
-
This article outlines the process of creating a measure to identify the top 10 products by sales each year. Read more
-
This article is about useful concepts and scenarios for integrating AI and AI agents in BI development, with specific examples for Power BI. Read more
-
Overview of the various capabilities of AI workflows and agentic development for Power BI. The focus is on AI for BI professionals, not conversational BI for data consumers. Read more
-
This advanced paper explains how SUMMARIZECOLUMNS works internally, providing insight into how to control its behavior in queries and measures following a list of best practices. Read more
-
When using time intelligence functions, the automatic REMOVEFILTERS on Date can make maintaining filters on the Date table challenging. This article shows a technique to handle filter-preserving columns in DAX. Read more
-
This article describes how to control the execution of DAX code when there are either multiple or empty selections of calculation items in calculation groups. Read more
-
This article explains why you might encounter a curious error when placing columns from unrelated tables in a Power BI matrix. Read more
-
Direct Lake + Import composite mode explained—architecture, performance tests, and where it outperforms pure Import or Direct Lake. Re‑recorded after my Fabric Conf 2025 session (the original wasn’t recorded), this walkthrough offers a critical take without the usual marketing pitch, so you can decide which storage… Watch now
-
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
