cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fonz11 Regular Visitor
Regular Visitor

Resources Exceeded This visual has exceeded the available resources.

Don't seethe address for emailing support anymore so I guess I have to post here. I'm getting this error message in service even though desktop handles it correctly: 

 

Resources Exceeded
 
This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.
Please try again later or contact support. If you contact support, please provide these details.

 

More detailsResource Governing: The query exceeded the maximum memory allowed for queries executed in the current workload group (Requested 1048581KB, Limit 1048576KB).
Activity ID0e143718-e839-42de-8c32-f9977ffa75cb
Correlation ID9a2bb89d-283b-4fff-6612-895a8de7b741
Request ID506e3957-29c7-a198-c460-c6a205d67907
TimeTue May 16 2017 11:15:00 GMT-0700 (Pacific Daylight Time)
Version13.0.1700.2143

 

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Resources Exceeded This visual has exceeded the available resources.

Hi @fonz11,

The above error message means that your visual has attempted to query too much data for us to complete the result with the available resources. Try filtering the visual to reduce the amount of data in the result.

Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-troubleshooting-tile-errors/

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ChrisHaas Established Member
Established Member

Re: Resources Exceeded This visual has exceeded the available resources.

Hi Fonz11 -

 

Power BI service has a limit of 1 GB RAM for any queries that it tries to run.  The Desktop version does not have this limitation.

 

You'll need to either simplify your query by removing a column or two from your table, removing a measure from your table, or tune and optimize your measures.

 

If you post your measure, the community may be able to help you tune it.

 

Marco Russo at www.sqlbi.com has some fantastic resources on optimizing queries.

Laz Member
Member

Re: Resources Exceeded This visual has exceeded the available resources.

Hi @ChrisHaas 

 

your comment is very helpful!

 

Just to confirm,

 

(1) Power BI has a limit of 1GB for each .PBIX file that is published into the PBI Service, as maximum Memory (RAM) allocation on the cloud cannot exceed 1GB per .PBIX.

 

(2) Is it possible to have a .PBIX that is under 1GB, therefore can we publish to the cloud, but a single visualisation exceeds the mximum Memory (RAM) allocation?

 

Thanks,

 

Laz