Forum Discussion
"Resources Exceeded" error
I want to show traffic lights for VTF%, values and totals.
I am using a dynamic conditional formatting Dax, like this:
So this is my conditional formatting rules:
But after I added that conditional formatting rule, the visual broke:
I don’t know what the “Resources Exceeded” error means, and how can I fix it.
Thanks so much!
Hi Anonymous ,
According to the documentation：
This visual has exceeded the available resources.
This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.
Your visual has attempted to query too much data for us to complete the result with the available resources. Try filtering the visual to reduce the amount of data in the result.
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. )
4. It may also be that your local computer has insufficient content space. You can turn off the memory that is not needed in the local computer when you turn on the power bi desktop.
This is the related document, you can view this content:
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,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous , Use this measure using the field value option instead of the rule, as it returns to color, that option is better
Also, you can use the Switch inside the switch for 3 condition
I this does not help, share measure in text format
Hi Anonymous ,
According to the documentation：
This visual has exceeded the available resources.
This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.
Your visual has attempted to query too much data for us to complete the result with the available resources. Try filtering the visual to reduce the amount of data in the result.
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. )
4. It may also be that your local computer has insufficient content space. You can turn off the memory that is not needed in the local computer when you turn on the power bi desktop.
This is the related document, you can view this content:
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,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
