Analyze memory usage in Power BI to improve performance

Описание: 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: https://docs.microsoft.com/en-us/sql/...


Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
   / @curbalen  

Our PLAYLISTS:
Join our DAX Fridays! Series: https://goo.gl/FtUWUX
Power BI dashboards for beginners: https://goo.gl/9YzyDP
Power BI Tips & Tricks: https://goo.gl/H6kUbP
Power Bi and Google Analytics: https://goo.gl/ZNsY8l

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

************



************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Linkedin: https://goo.gl/3VW6Ky
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB

#SUBSCRIBE #CURBAL

#DATAMODELING #CURBAL #POWERBI #MVP