Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @tim_m15 ,
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
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.
Hi @tim_m15 ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.
Best Regards,
Eyelyn Qin
Hi @tim_m15 ,
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
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.
@tim_m15 , 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-i...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |