Crunch Massive Datasets with Power BI Aggregations
Do you have large datasets in Power BI that are sluggish?
Do you want to be able to connect to hundreds of millions to billions of rows in Power BI and still use it without any lag?
If yes, then Power BI Aggregations could be the answer for you.
We connected 2 Power BI Reports to the same sample data warehouse database, which contains 100 million rows of sales related retail data.
The first model utilises a Direct Query connection to the database. The second model utilises a Composite Model connection with the addition of the Power BI Aggregate table and managed aggregations.
The Power BI Dashboard utilising Power BI Aggregations adds massive performance gains as displayed in this demo.
Microsoft show case this capability with petabyte scale one trillion row dataset: