Not enough memory

[GraceTCL]

Hi 

I have below error in loading:

This is despite the fact that I have reduced to 5 months of data and aggregated my data but still I encountered this error. In addition, power bi is attempting to find a deleted "Food Data" table which I am not sure why. I dont need this deleted table already. Pls advise. Thank you.

[TomMartens]

Hey @GraceTCL ,

maybe the "Food Data" table is referenced by another query, somewhere upstream in your data processing.

Next to that, it's almost impossible to provide more guidance, without being able to touch the pbix, at least not for me.

In regards to your memory issue, how many rows and columns are you using, I have to admit that I never have seen this error message during using Power BI desktop and saving the PBIX file. As my laptop has 64GB of RAM.

If you receive this error during publishing the report to the Power BI service you have to be aware of the limit that the size of the data is limited to 1GB if you are using Power BI Pro licensing: Manage data storage in your workspaces - Power BI | Microsoft Docs

Hopefully, this helps to tackle your challenges.

Regards,

Tom