Forum Discussion
Memory error: Memory Allocation failure | Not enough memory to complete this operation
Just for a reference, updating Power BI Desktop to latest release has solved my issue. - if this can help anyone.
Hi InsightsByV ,
What's the size of pbix file? Did you open it in Power BI Desktop or Power BI Service?According to the error message, it seems that the memory is not enough. But as you said your friend can open it successfully, then the size of pbix file is OK. Please try to follow the methods in the following links to make some adjustment, later check if you can open the pbix file successfully.
Power BI Memory error allocation failure
- If you are using the service on a Virtual Machine, check if the allocated memory is enough for the operations.
- Since you are getting this error, try to allocate more memory to the machine.
- You can also try to better utilize the available memory by optimizing your data model.
- You can check the Internet for guides on optimizing your data model.
Memory error: Memory Allocation failure.
I went into the query editor and removed as many columns as possible and the refresh started working again. Also, I received this nugget of wisdom from Support:
From a memory consumption perspective it is better to add columns in the report developer using the add new measure/column function for optimized performance.
Best Regards