Forum Discussion
There's Not Enough Memory To Complete This Operation
Does it always fail? What about after a reboot?
Ensure you are using 64bit to make best use of memory.
Are you on the latest version?
It always fail, there is daily reboot. We use 64bit memory, profi server memory. It is problom in powerBI not in HW.
Latest version, yes, of course.
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.
Greetings, to me this seems to be a 'bug' in the memory management of the widgets. I have done this in the past versions with no ill affect but in the past 2 versions this has become an issue.
I have a lot of memory available and I am simply pulling a list of dimension objects in (SSAS MD Cube) into a simple table widget. All works well returning less then 100 rows, 4 columns of data. When I add one more Fact column...memory issue happens. Pull that fact item out and add another dim item (now at 5 columns)...no problem.
Yes, when I filter the data down to a few records it returns fine. However the process to use the UI is to allow the end user to filter down to get a question answered that would imply the initial rendering would not be filtered and should have the capacity to handle, to some real memory limit, a large dataset. This also fails in a similar way when the report is deployed into PBIRS and view via the browser.
Anonymous Were you able to resolve this issue? I have the same problem with the table widget.
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.
