Forum Discussion
There's Not Enough Memory To Complete This Operation
Are you doing anything complex? E.g. lots of pivots/unpivot merge duplication & functions.
Are you able to reduce the data sets or disable some of the queries to see what if will complete and isolate where the problem may be.
It should easily cope with 67Mb of data so it might be worth loggin a support ticket to get help.
If you have lots of queries does it get stuck running them all? I have sometimes had to run them one at a time due to time outs.
Are you using Direct Queries? If so try the Query Reduction Options.
Also try different options on the Data Cache (under Data Load in settings) however I've never needed to change these.
For me, my laptop has a 4 GB RAM and before I run Power BI, there is like 2 GB RAM left. My data set was like 80 MB big. The first 70 MB went smoothly but when it came to the last 10 MB, it suddenly sucked up all the RAM and tell me there is not enough memory. I only applied several basic filters and sorted steps. The os is WIN 10 and the Power BI is the lastest version.
Powerbi is a memory hog so running with just 4gb is going to be challenging.
Whats your data source? Can you filter/sort it before loading?
However I did some tests on a 140Mb file and it tended to only use about 0.6G extra ram during the load on top of powerbi's intital size.
Doing a group by and big pivot took upto 3gb extra.
Well. I think maybe I need a better laptop. Thank you so much for your reply.