Forum Discussion
There's Not Enough Memory To Complete This Operation
I ran into the same problem, and I have 8gb of RAM as well.
Once I figured out which of the tables is causing the problem, I uploaded the model without that specific table. Then, I opened the query editor and uploaded just that table there.
Once you upload a table in the query editor, it allows you to edit the data before uploading it to the data model. I filtered only the data I needed (in my case it was a log table, so I filtered only the past three years) and only then clicked "apply".
In my case it worked great.
Here are some of my memory tips for powerbi.
Power BI is definately a memory hog. I use it with a 16Gb machine. 8gb works for most of our users. Restart if you get problems and make sure your memory has been release which can take a while. Close other memory hogs like browsers.
Obviously removed unneeded columns.
Aggregate in SQL or M to a lower grain before you load if you don't need all the detail.
Filter out rows you don't need again in SQL or M. Maybe only bring the last x days/months data.
Aim for a star schema if possible with id keys joins. Try adding a date dimension with your reporting month and join to your dates.
Turn off the Time Intelligence Auto Date/Time option if you don't need it as create date dimension in the background for every date field from the smallest to largest dates.
Also reduce the precision of times if you dont need them to be highly accurate.
Ideally load date and time seperatly both as integers e.g. mins after midnight.
I read here that ordering the data can help the compression if the data is very large. > 1million rows.
https://powerpivotpro.com/2016/02/sort-data-load-improved-compression/
here is some details of looking at what is using storage in your model.
https://www.sqlbi.com/articles/data-model-size-with-vertipaq-analyzer/
If you still too big then you may need to use either SSAS tabular on a server or try Azure Analysis Services (which can import your powerbi model)
https://azure.microsoft.com/en-gb/services/analysis-services/
How big is the final powerbi doc? I have a couple of docs that are 0.5Gb.
Phil
Hi, I ran into the same problem when only refreshing 67MB data. Do you have any idea why it failed?
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.
no, file has just 24MB :-).
- I have extra virtual machine for that, so all memory is just for powerBI. Complete refresh works ok just with 64GB ram.
- I am using just important columns and only one year (bookeeping). Problem is that I have there about 50 companies, not big data, just two have about 100k rows, but most of other has just about 10-20k rows.
I suppose the problem is not because of amount of rows, but becuase of 50 data sources.
- I tried that function "separately refreshing" or so, but it didnt help.
