Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am loading the data from SQL server. I am trying to refresh the data for my tables. But the data is not able to refresh and the below is message is reported:
The operation could not be completed as you do not enough memory. Please try again after you have enough memory. Please some body can help. FYI I have 8 gb of Ram.
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.
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.
Do you have 64 bit Power BI? If not, you should get it.
How many columns in your tables you are loading? If you have more than 15 in a large table, then try removing columns you don’t need
I have already installed 64 bit Power BI Desktop and the number of rows are obviously more than 15 as there too many tables.
@Kumar11109 wrote:the number of rows are obviously more than 15 as there too many tables.
It is not the rows that matter, it is the columns. My question was how many columns do you have. I don't know what "too many tables" means
Hi Matt,
I am really sorry, I meant that 15 columns only. And I have 8 tables with relationship across them and no table has more than 15 columns individually, but if combined, then yes.
Thank You,
Hi @Kumar11109,
The error message means you don't have enough memory. Please extend your memory as much as possible. You can refer to this article(though the article is about PowerPivot, it should be similar with Power BI) to optimize your data model in a way that makes a better use the available memory. For another thing, if you upload the data in import model, please disable "Allow data preview to download in the background" from options / options and settings/data load. And check if it is useful.
Best Regards,
Angelia
Hi @Kumar11109,
When you create a simple table in Power BI desktop, there is no problem for Power BI function. You have to extend your memory.
Best Regards,
Angelia
Ram ??? if I have to increase it, then would 16gb be enough??
When I had there only 15 sql databases (company bookeepings) it need just about 16GB ram during total refresh.
Now I have there about 39 companies and it need 41GB of RAM. I had to ask my bosses for stop buying new companies 😞
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |