Very high memory consumption on refresh

Question

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

mwegener · Answer

Hi&nbsp;tomislav&nbsp;,
&nbsp;
use the Query Diagnostics...
https://docs.microsoft.com/en-us/power-query/querydiagnostics
&nbsp;
&nbsp;

mwegener · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
what is your data structure?&nbsp;How many tables, columns and rows do you use?
In the PQ Editor you only work with a preview of data.
After hit Close &amp; Apply in PQ,&nbsp;the entire dataset is loaded from the source into the Power BI Data Model.
&nbsp;
&nbsp;
&nbsp;

greg_deckler · Answer

Have you run Query Diagnostics from the Tools menu in Query Editor?

amitchandak · Answer

tomislav ,
Refer, if this can help https://docs.microsoft.com/en-us/power-bi/desktop-performance-analyzer

anonymous · Answer

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 &amp; Apply in PQ.&nbsp; 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?

Forum Discussion

Related content

Memory consumption issue while refreshing the data source

Trying to understand refresh memory usage

PBI Memory Consumption and Refresh Problem.

Semantic model Refresh memory limit error

Semantic Model Refresh - Memory limit