Views: 5302 , Video Rating: 5.00 , View Time: 17:27 Minutes, # of Likes: 67, # of Disslikes: 0
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.
Link to DMV site:
Looking for a download file? Go to our Download Center:
SUBSCRIBE to learn more about Power and Excel BI!
– Join our DAX Fridays! Series:
– Power BI dashboards for beginners:
– Power BI Tips & Tricks:
– Power Bi and Google Analytics:
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
Many thanks in advance!
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +:
#POWERBITIPS #CURBAL #POWERBI #MVP
#DATAMODELING #CURBAL #POWERBI #MVP