Forum Discussion
Very high memory consumption on refresh
HI, I have very high memory consumption when I load from Power Query to PBI Desktop or when I'm doing plain refresh. My question is how can I see what is eating so much memory?
Thanks
9 Replies
Hi tomislav ,
use the Query Diagnostics...
https://docs.microsoft.com/en-us/power-query/querydiagnostics
Thanks for inputs, I work with DAX Studio and Tabular Editor, and I did all the things for memory optimization, and I do not have any memory problems on PQ level, first sign of trouble is hit Close & Apply in PQ. Load takes 2-3 minutes, and goes from 4GB RAM to 32 GB. Problem is that I do not see what is sucking RAM to level of 32GB? Does model do refresh of all report pages when it loads from PQ? Or is it coming from calculated tables and calculated columns?
Hi Anonymous ,
what is your data structure? How many tables, columns and rows do you use?
In the PQ Editor you only work with a preview of data.
After hit Close & Apply in PQ, the entire dataset is loaded from the source into the Power BI Data Model.
Have you run Query Diagnostics from the Tools menu in Query Editor?
tomislav ,
Refer, if this can help https://docs.microsoft.com/en-us/power-bi/desktop-performance-analyzer
