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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors