Performance Issue - High Importance

[Vamshi2020]

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

[Anonymous]

@Vamshi2020 

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.

[amitchandak]

@Vamshi2020 ,aggregations can help. Refer

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