In this article, we look at a performance comparison between header/detail models and star schemas. Building a star schema might require a few ETL steps and some coding. Nonetheless, it is always the best modeling option.
Read more
Parent-child hierarchies are often used to represent charts of accounts, stores, salespersons and such. Parent-child hierarchies have a peculiar way of storing the hierarchy in the sense that they have a variable depth. In this pattern we show how to use parent-child hierarchies to show budget, actual and forecast values in a report using both a chart of accounts and a geographic hierarchy.
Read more


Latest videos
Checking Boolean conditions while creating a like for like comparison in DAX
32:49#unpluggedAlberto Ferrari
Deep dive into measure filters in Power BI Desktop
23:03Alberto Ferrari
02:39#daxguideAlberto Ferrari
01:55#daxguideAlberto Ferrari
02:34#daxguideAlberto Ferrari


Latest news
• Power BI September 2021 updates
In September Microsoft released a new version of Power BI, but also an updated data gateway and a new version of Power BI Report Server. No big news, many small improvements.
Sep 21, 2021 · Microsoft
• Using PowerShell to run Power BI DAX queries and extract data to CSV
You can build your query in DAX Studio using the query builder if you do not know DAX. You can then export the data to CSV files (which are Excel friendly, you know) by using the REST API. Repeat and automate the process with PowerShell.
Oct 8, 2021 · Gilbert Quevauvilliers
• Parent-child hierarchy scripting with Tabular Editor
Scripts in Tabular Editor allow you to automate boring and repetitive manual operations. One example is when you want to create calculated columns to implement the parent-child hierarchies pattern above. Not to be lazy, just more efficient, right?
Aug 27, 2021 · Sergio Murru
• Preserving data types with SQL queries in Power Query and Power BI
When you use native SQL queries in Power Query, you might experience a data type change that requires additional transformations in Power Query. A simple property can save you valuable time. Productivity, again!
Sep 12, 2021 · Chris Webb
• Tabular Editor 2.16.4
Even though Tabular Editor 3 dramatically increases your productivity, you can always rely on the free Tabular Editor 2 if you cannot use the commercial version. The project is alive and kicking, getting fixes and updates.
Sep 27, 2021 · Daniel Otykier