Very high memory consumption on refresh

[tomislav]

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]

Hi @tomislav ,

use the Query Diagnostics...

https://docs.microsoft.com/en-us/power-query/querydiagnostics

[Anonymous]

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?

[mwegener]

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.

[Anonymous]

Total size of file 220MB, 39 tables,484 columns.

[mwegener]

Hi @Anonymous ,

what data source are you using?

Are all columns and tables really needed?

it is recommended to reduce the required data at the source as early as possible.

This reduces the required bandwidth, memory, etc.

[v-lionel-msft]

Hi @Anonymous ,

It may be that the data imported is too large (If you used Direct Query mode, it may be that the performance of the server where your data source is located is too poor), causing the query to consume too much computer resources.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

No, I work in Import mode not Direct Query. I will try returning to last working version of file and start from there. Thanks

[amitchandak]

@tomislav ,

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

[Greg_Deckler]

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