Forum Discussion

Kumar11109's avatar
Kumar11109
Icon for Helper IV rankHelper IV
8 years ago

There's Not Enough Memory To Complete This Operation

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 n...
Need Help
pandakillsalot's avatar
pandakillsalot
Icon for Helper II rankHelper II
8 years ago

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. 

stretcharm's avatar
stretcharm
Icon for Memorable Member rankMemorable Member
8 years ago

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.

  • pandakillsalot's avatar
    pandakillsalot
    Icon for Helper II rankHelper II
    8 years ago

    Well. I think maybe I need a better laptop. Thank you so much for your reply.

Related content