Forum Discussion
There's Not Enough Memory To Complete This Operation
Anonymous Were you able to resolve this issue? I have the same problem with the table widget.
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 :-)
- hamster6 years agoNew Member
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_Mathur6 years agoSuper User
Hi,
There is absolutely no such limit at all. I have dealt with much larger datasets with a lot of ease.
- hamster6 years agoNew Member
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?