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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors