Forum Discussion
Not Enough Memory to Complete This Operation Error
Hello,
I am working with a large (~1.2GB) .pbix file. It has always opened fine on my PC until yesterday, 6/15/2022. Now, when I try to open it, I get an error before the report can open saying "There's not enough memory to complete this operation. Please try again later when there may be more memory available."
There is no obvious disproportionate consumer of memory showing in Task Manager. My hardware is the same and did not get damaged somehow. I have tried opening backdated versions of the report that I know I was able to open previously, and I no longer can due to the above error.
The .pbix file opens for a colleague on a PC with the same specs as mine, and I can open it on my personal PC, all running the most recent version if Power BI Desktop. So I know the .pbix file is still functioning. I also uninstalled and reinstalled Power BI desktop on the affected computer, and that did not seem to help either.
Power BI Desktop version 2.106.582.0 was published on 6/14/2022 and is the only variance I can come up with that could have led to this overnight change. Has anyone else had this issue opening large .pbix files, or does anyone have a potential soluton?
Thank you!
4 Replies
that is an interesting error could be the update. have you tried clearing your cache? Is there anyone else who hasn't updated their power bi that you could ask to validate if it opens on there side. Has any data changed in the background?
Hi Vanessafvg,
Thank you for the suggestion! Taking your advice, I used the Windows Disk Cleanup application to delete temporary files and clear my Recycle Bin. I also cleared the Data Load and Q&A Cache's through the Power BI Options > Data Load interface. I restarted my PC afterwards and tried to open the file. Unfortunately, the error persisted.
Some additional details I will also add to my original post is that the .pbix file opens for a colleague on a PC with the same specs as mine, and I can open it on my personal PC, all running the most recent version. I also uninstalled and reinstalled Power BI desktop on the affected computer, and that did not seem to help either.
If there are any other caches to clear that I missed, or if you have any other thoughts, please let me know!
yes the auto recovery folder - often there are orphaned versions. I know for me its caused issues previously but not recently. give ita try maybe it will help.
under your file / options and settings / options
got to the global auto recovery tab and click on open auto recovery folder, and check that you dont have a lot of files in this folder that might be taking up a lot of space.
