New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Analyze memory usage in Power BI to improve performance using DMV queries

In today’s video I will show you how to measure memory usage in Power BI.
We will go through a specific case where I improved the performance of a Google Analytics report created using Power BI.
We measured the size of the columns by using DMV queries in power bi and identified which columns where using up most of the memory.
This report was loading page speed data for more than 3 years and as those columns can not be compressed effectively by the power bi engine, they were making the power bi model very slow. By loading less data and/or reduce cardinality of those columns, better performance can be achieved.

Watch the tutorial:

Analyze memory usage in Power BI to improve performance

Links to the mentioned resources

Link to DMV site:
https://docs.microsoft.com/en-us/sql/…

Was this helpful?
Next Make your Direct Queries run faster in Power BI | Assume referential integrity

Reader Interactions

Let us know your thoughts...

Table of Contents