Forum Discussion
Helper IVHow to resolve memory issue in Power BI Desktop
Hi Team,
Getting memory error while i am refreshing the data from SQL server into PBIX file. My PBIX file is of 50mb and there are 1214837 rows and 55 columns in it. Even i am trying to clear few unnecessary calculated column form it but it does not allow me due to not enough memory available.
Please note i have tried few steps to overcome this but still issue is there. I tried to clear the cache memory of Power BI desktop and increased the Allowed memory from 4096mb to 10000mb. I cleaned up temporary files from system. Previously with this mb it was working fine but from past couple of days it is behaving abnormally.
Here the message which i am getting while applying refresh option.
Please suggest if anything i need to follow to get over this! Your help is much appreciated.
Regards,
Sagar
2 Replies
- amitchandak
Super User
sagarsahoo_123 , Make sure enough RAM and Hard disk is free when you are running power bi. Increase virtual memory of the system if needed
Memory Need
https://www.linkedin.com/pulse/ten-techniques-optimising-memory-usage-microsoft-power-dejan-pajk/
https://www.designmind.com/business-intelligence/power-bi-performance-issues/
https://blog.crossjoin.co.uk/2020/05/21/monitoring-power-query-memory-usage-with-query-diagnostics-in-power-bi/ 
sagarsahoo_123Hi amitchandak ,
In my system having 16GB RAM and enough memory and even i am not opening any other application while running this.. It was working earlier but not sure all of sudden how it gave such error message!
