cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VinnyH
Frequent Visitor

Visual has exceeded available resources

Hi,

I'm having problems getting a visual to display properly in the Service, where it's fine on desktop.

Now, I understand that it's a very large amount of data that the visual is trying to display.

The visual will display as broken with the text "Visual has exceeded available resources"

 

My question is - would having Power BI premium be a resolution to this?

 

We're currently trying to provide a compelling reason for purchasing it to the decision makers in our company and want to be sure we're selling it to them as a solution for the right reasons!

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

Hi @VinnyH ,

 

The error occurs when a visual attempts to query too much data for the server to complete the result with the available resources.  You may need to filter the visual to reduce the amount of data in the result currently. That way, the error might be resolved.

 

You can also optimize your data model following the guide in the blogs below, and re-publish your PBIX file to Power BI Service.

Power BI Performance Tips and Techniques

Data Import Best Practices in Power BI

 

If you still have this issue, you may purchase Power BI Premium capacity for your organization, see What is Power BI Premium? , How to purchase Power BI Premium.

 

Best Regards,

Amy

 

Community Support Team _ Amy

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
v-xicai
Community Support
Community Support

Hi @VinnyH ,

 

The error occurs when a visual attempts to query too much data for the server to complete the result with the available resources.  You may need to filter the visual to reduce the amount of data in the result currently. That way, the error might be resolved.

 

You can also optimize your data model following the guide in the blogs below, and re-publish your PBIX file to Power BI Service.

Power BI Performance Tips and Techniques

Data Import Best Practices in Power BI

 

If you still have this issue, you may purchase Power BI Premium capacity for your organization, see What is Power BI Premium? , How to purchase Power BI Premium.

 

Best Regards,

Amy

 

Community Support Team _ Amy

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

synergised
Resolver II
Resolver II

We have had several of our reports (running for over a year) start failing with the same error this week.  Apparently the latest upgrade pushed out this week changed a resource limit of some kind.  We just have Power BI Pro.

 

Also of note, the mobile reports hit the resource limit way before the desktop version. 

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors