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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
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

skocheta's avatar
skocheta
Advocate I
8 years ago

This simply does not make any sense without considering the data size, result size, type of visuals etc.

For intsnace, In my POC environment there are 34000 Rows even after all the joins. I have a tabular view which is displaying not more than 40 Rows currently (8 Columns).

As soon as I try and add Another column, the visual fails.

One of the column is a Measure returning Data in relevant currency.

 

I can't understand How inefficient my query could be to make resources so scarce !