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 →

The challenge I encountered when using this approach was that newly inserted data did not become visible in the table immediately. In most cases, it took one or two minutes before the records appeared in the table, and even longer … Continue reading →