Forum Discussion
The visual has exceeded the available resources.
Hi team,
Facing the error "The visual has exceeded the available resources" (The visuals are filtered for 2024-Q2 and AMERICAN geography)
Could someone please help me on this?
been struck with this from past 2 days!!
3 Replies
- Greg_Deckler
Community Champion
sharath_15 Typically this is the result of a complex measure. Is this an import model, a DirectQuery model, a Live model or ? You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET". - AnonymousNot applicable
Your ideas is so great Greg_Deckler and SaiTejaTalasila
Hi, sharath_15
As Greg_Deckler and SaiTejaTalasila said, your dataset is undergoing complex calculations and has too many columns and data in the visual to exceed the limits of one visual. You can see the current limitations in the documentation below:
Set visual query limits in Power BI Desktop - Power BI | Microsoft Learn
Try filtering the visual to reduce the amount of data in the result.
refer:
This visual has exceeded the available resources.
And you can follow the tips to optimize your report:
1.Do not expose in a view a column that is not necessary in the Power BI data model.
2.Optimize the DAX calculation used in this visual to use less memory and return faster or change what the visual displays.
3.Remove unnecessary precision or split granularity values to reduce cardinality(Significantly reduce highly unique datetime values by splitting the date and time into separate columns. )
refer:
The “Visual Has Exceeded The Available Resources” Error In Power BI
Visual has exceeded the available resources - Table Visual
Data Import Best Practices in Power BI
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- SaiTejaTalasila
Super User
Hi sharath_15 ,
The backend query generated by your visual is taking too much time more than 225 sec.If your report is import query one then you can reduce some data on the semantic model it will help you to fix the issue or you can modify your visual and check even it will help to the issue.
Thanks,
Sai Teja