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

Visual has exceeded available resources

Hi,

 

I am receiving this error on both Power BI Desktop and Power BI Service(More often on Power BI Service).

 

error.PNG

 

The visual in question does use about 10 measure and I think this is one of the reasons I am getting this error.

 

To resolve this

-I tried to aggregate the data at the SQL server database side and pulled the aggregated data into power bi.

-Restricted the measure calculations to only a year.

 

Let me know what else can I do to resolve this error?

The sizes of 2 tables I am using are about 65k rows and 8 coulmns.

1 REPLY 1
Community Support Team
Community Support Team

Re: Visual has exceeded available resources

Hi @kdesai

the issue occurs when a visual has attempted to query too much data for the server to complete the result with the available resources. 

As suggested in the error, you may need to try filtering the visual to reduce the amount of data in the result currently.

 

each visual on your dashboard cannot exceed 16MBs .

Try removing some details, reduce the number of dimensions and measures within the visuals that are failing. 

 

For building fast and reliable reports in Power BI. Please refer to “Power BI Performance Best Practices “

 

Best Regards

Maggie

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 134 members 1,685 guests
Please welcome our newest community members: