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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Follow up:

 

Is there any update, I am sitting at client's heat and don't have any words at the visual exceed limit error at power BI service reports.

 

Can anybody help me with this?

  • Ged's avatar
    Ged
    Helper I
    7 years ago

    Dear all

     

    We were dealing with this issue a year and a half ago and it was an absolute pain. We had numerous conversations with the official Microsoft support at the time and, in all honesty, they couldnt help much except for advising us that the issue was our SQL Server (queriestaking more than 5 seconds...); limit the number of the visuals in a single report. In a nutshell, limit the amount of data to be fetched; make sure to put solid indexing. 

     

    So:

     

    1. Check the SQL query performance. End-result in Power BI depends on the performance of your backend. 

    2. Further tune it with indexing. 

    3. Consider having an SSAS solution of your data instead of taping on schema tables directly.

     

    good luck.