Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
GeorgWildmoser
Frequent Visitor

Service: Visual has exceeded available resources. Desktop: it works

Hi all,

 

i have a problem with one visualization in PowerBI service. The error is: Resources Exceeded. This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed. Please try again later or contact support. If you contact support, please provide these details. ....

 

On the Desktop, the queries run immediately with a little delay. I appreciate if anyone can help me.

18574_Fehler.png18574.png

2 ACCEPTED SOLUTIONS
Tutu_in_YYC
Super User
Super User

Hi George
on power bi desktop, the resource is based on your laptop/computer, where as in the service, it is based on the shared capacity ( if you are not using Premium Capacity). 

Try simplifying your DAX calculation or reducing the data to be visualized in the matrix. Adding filters in the page helps too.

View solution in original post

Anonymous
Not applicable

Hi  @GeorgWildmoser ,

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi  @GeorgWildmoser ,

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.

Tutu_in_YYC
Super User
Super User

Hi George
on power bi desktop, the resource is based on your laptop/computer, where as in the service, it is based on the shared capacity ( if you are not using Premium Capacity). 

Try simplifying your DAX calculation or reducing the data to be visualized in the matrix. Adding filters in the page helps too.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.