Visual has exceeded the available resources error

[Vallirajap]

Hi All,
I am facing a new issue. When I publish my report in PBI Service, some visuals are getting the "Visual has exceeded the available resources" error. But it was perfectly working on the PBI Desktop. What is the reason, and how can I retrieve the error?

Is there any option available in the PBI Service to improve the memory or time limits for the report?

Any one who knows, please tell.
Thanks in advance..!

Regards,
Valli Raja P.

[Brunner_BI]

@Vallirajap try to remove all unused columns and measures from your model via Measure Killer and see if that helps.

[AnkitKukreja]

Hi! @Vallirajap 

Look at the suggestions suggested by @Idrissshatila also you can look out for previous solved solutions, as this is a very common issue. Here's the one that might help https://community.fabric.microsoft.com/t5/Service/Getting-visual-has-exceeded-the-available-resource...

[Idrissshatila · Accepted solution]

Hello @Vallirajap ,

There are two possible solutions:

1.Refer to the official documentation provided:

Troubleshooting tile errors - Power BI | Microsoft Learn

2.Optimize the model and the query.

For more detailed information on optimizing Power BI models, see the following documentation:

Optimization guide for Power BI - Power BI | Microsoft Learn

Improve Power BI Performance by Optimizing your DAX | by MAQ Software | MAQ Software | Medium

How to Optimize Dax Queries in Power BI - Zebra BI