Visual has exceeded the available resources error

[Turquesa]

Hi Everyone!!

I am hoping you can help me with an error which is giving me a big headache! I have created a new power bi report which is a copy of an existing power bi report which works perfectly fine. In this newly created power bi report I have removed from the data sources some of the data (a large number of invoices - as this is a filtered down version). I am mentioning this because in this new version of the report I am getting the "visual has exceeded available resources" error when I connect the tables using same relationship I had before (using the invoice document number which is documented in both tables). I have tried several things (such us deleting the table from model, copying the excel file in a new tab, changing from excel to csv...) but I am still getting this error - not sure what the matter is as this I have the same copy of the report with larger data sets and same measures, relationships, etc.

Any thoughts??!

Thanks in advance!

[v-kaiyue-msft]

Hi @Turquesa ,

Thanks for the reply from @manvishah17 , please allow me to provide another insight: 

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.Adjust the DAX calculations used in this visual (I suggest you read the section on materialization from p568of "The Ultimate DAX Guide" or this previous article covering the same terrain) to use less memory and return faster or change what the visual displays.

2.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. )

3. 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

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[manvishah17]

Hi @Turquesa  ,
To address the "visual has exceeded available resources" error in Power BI, follow these steps:

Simplify the Data Model:

Remove unnecessary columns and relationships.
Aggregate data at a higher level before importing.
Optimize DAX Queries and Measures:

Simplify complex measures.
Avoid calculated columns; use measures instead.
Optimize Data Loading and Query Performance:

Ensure query folding is happening.
Set correct data types.
Apply filters early in the data loading process.

Diagnose with Performance Analyzer:

Use Performance Analyzer to identify resource-heavy visuals.

Incremental Refresh:

Use incremental refresh for large datasets to improve performance.

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

@Turquesa

[Turquesa]

Hi @manvishah17  I have tried all of the above and as I mentioned in my post I have been able to display the data and all the visuals in a larger and more complex report I created some time ago using exactly the same template and sources.