cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
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
Highlighted
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. 

 

Highlighted
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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors