Forum Discussion
Performance Issue - High Importance
Hi All,
I am in urgent need of Experts help here. we are doing some dashboard development which has round 10 Tables and out of these 10 around 4,5 tables have data around 10M . our calculations are simple and dont have any bookmarks also
we are doing the data model in one pbi file and visualization in another using live connection. But we are facing very bad performance issue and most of the times visuals are throwig memory error and "Visual exceeded available resources" Error. So, please help me to improve the Performance issues in Dashboard.
TIA
2 Replies
Vamshi2020 ,aggregations can help. Refer
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations
The issue occurs when a visual has attempted to query too much data to complete the result with the available resources. As suggested in the error, you may need to short the data shown by removing redundant data, aggregating or filtering reduce the amount of data in the result visual.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
