Forum Discussion
Very high memory consumption on refresh
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.
Total size of file 220MB, 39 tables,484 columns.
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No, I work in Import mode not Direct Query. I will try returning to last working version of file and start from there. Thanks
