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
ludovit8's avatar
ludovit8
Icon for Helper I rankHelper I
7 years ago

yes, you had to change the structure and logic of your data model. I am not able explain it better in english, but try to make new merged tables with some logic and then turn off "load" of old data connections. Or ask some dax profesional how to solve it :-)

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?

Related content