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
hamster's avatar
hamster
New Member
6 years ago

This is the solution for this problem if you are having issues using CSV or EXCEL as the data source. For my expereince. My data source is excel and number of data rows is 95k. Power BI desktop is having issues loading the data and returning a memory issue.

 

Solution: Trimmed down the data to 35k Rows and the issue has been fixed!

 

Question though : Why Power BI Cannot handle 95k worth of data rows? That is very small in data analytics. Seems like Power BI is just designed to handle small amount of data?

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

There is absolutely no such limit at all.  I have dealt with much larger datasets with a lot of ease.

  • hamster's avatar
    hamster
    New Member
    6 years ago

    That's what i thought too but after several tries it didn't work until we trimmed down to 35k data rows.

     

    Power BI Bug?

Related content