I increasingly encounter developers who want to create reports in Power BI Desktop but face a common challenge: their fact tables contain a large number of rows, and their development machines lack the resources to process that volume of data. … Continue reading →

Power BI reports are typically developed using metadata in a single language. This means that table and column names, as well as measures and hierarchies, are defined in one language. For example, when I develop a report or semantic model … Continue reading →

In one of my previous articles on partitioning, I described how Power BI data models can be partitioned using the XMLA endpoint. One limitation of that approach was that tables could only be partitioned using SQL Server Management Studio. In … Continue reading →

The new Power BI Desktop Bridge feature was recently released in preview. At first, I had read that it could only be used with Claude. However, that is not the case. Since I already have a ChatGPT subscription, I can … Continue reading →

In my previous articles, I demonstrated how to create both a Date dimension and Calculation Groups directly in Power BI Desktop using TMDL. A common challenge in real-world projects is making these reusable objects available to multiple report developers. Especially … Continue reading →

In many organizations, organizational structures, cost center hierarchies, or product groups are not stored as traditional hierarchies with fixed levels. Instead, they are modeled as so-called parent-child structures, where each organizational unit only references its immediate parent. While this approach … Continue reading →