Forum Discussion

jgarciabu's avatar
jgarciabu
Advocate I
9 years ago
Solved

visual has exceeded available resources

Hi All,   I've been using PowerBI for the better part of a year now. For the last month and a half or a little more, we've had annoying failures to refresh for 6 of our 14 tile visualizations. It's...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi jgarciabu,

     

    Yes, 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.:smileyhappy:

     

    Regards

PMY1965's avatar
PMY1965
Advocate I
2 years ago

I got this error message today with my SWITCH. Power BI doesn't allow over 50 conditions in the function.    Update:  I found Chris Webb's solution.   I double Query Limit in Report settings  and it works.

 

 

Jeanxyz's avatar
Jeanxyz
Power Participant
2 years ago

Does changing the query limit works for PB Service or not? I understand from Chris Webb's blog, this tuning only work in Power BI Desktop, so won't you have the same issue again?

 

also I'm not sure if  more than 50 conditions can cause the issue. In my case, my Power BI report works online at the beginning, but one year later, I start to get capacity error message. I didn't make any change with the measures during the period, so my problem can only be caused by data size.