I started getting this error in my dashboards from few weeks " This visual has exceeded the available resources".
Dashboards are uploaded online on a workspace. Dashboards worked fine for a year , but from few weeks only some reports just stopped working at all. It does not matter what filters I choose, nothing works at all. The details of the error is copied below.
Your help is much appreciated.
Thanks in advance for your support!
More details: Resource Governing: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. To run this query, you could simplify the query or its calculations, or reach out to your capacity administrator to see if they can increase the per-query memory limit. More details: consumed memory 1331 MB, memory limit 1331 MB. Learn more, see https://go.microsoft.com/fwlink/?linkid=2159752.
Activity ID: bb7e5d65-a4b7-442d-8529-0af9da13d7d6
Correlation ID: 870fa7e6-1964-3c2b-570a-b95a7cc3e4eb
Request ID: 004a0c05-f3c9-44f9-bf33-62e4aafbb81c
Time: Tue Mar 28 2023 16:25:19 GMT+0200 (Ora legale dell’Europa centrale)
Service version: 13.0.20342.55
Client version: 2303.3.12949-train
URI cluster: https://wabi-west-europe-d-primary-redirect.analysis.windows.net/
Hi @alice_franchini ,
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
Community Support Team_ Caitlyn