Not enough memory - Couldn't load data for this visual

[Anonymous]

Hi,

the table in my report is filtered by different slicer. So my 40 million rows data from my dataset is reduced successfully.
Nevertheless, the calculation always canceled after several minutes (3-4) due to an memory error (See my uploaded screenshot). By the way, 3-4 minutes of loading time is indisputably long. User experience is really important to me.

I have read all relevant community posts so far, I don't know what to do.

How it is possible to display data in my table in an acceptable amount of time? That the user experience doesn't suffer.
Thanks for your feedback.

[Anonymous]

Hi @Anonymous ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

Hi @Anonymous ,

It may be caused by the data model being too bloated(large data model , complex queries...) and low local machine configuration. 

Please kindly check how much RAM and CPU Power BI is taking. And refer the official document to optimize the data model.

Hope these help:

https://community.powerbi.com/t5/Power-Query/How-to-Optimize-Memory-Usage/td-p/57915

https://community.powerbi.com/t5/Desktop/Coundn-t-load-the-data-for-this-visual-There-s-not-enough-memory/m-p/1350961

Best Regards,
Eyelyn Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Create aggregated tables

refer

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations

also refer : https://www.linkedin.com/pulse/ten-techniques-optimising-memory-usage-microsoft-power-dejan-pajk/
https://www.designmind.com/business-intelligence/power-bi-performance-issues/
https://blog.crossjoin.co.uk/2020/05/21/monitoring-power-query-memory-usage-with-query-diagnostics-in-power-bi/