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

hourir2's avatar
hourir2
Advocate I
2 years ago

** Potentially may help **
Hi all,

Had this error today in a MATRIX visual. I was pulling a column (Transit Stage) into the "Values" part of the matrix. Tried a simple filter on "Transit Stage" and got the "Resources exceeded" error.

I then realised i was filtering on the First [Transit Stage] value (see circled filter below), which was causing the issue, instead of filtering on the actual column itself.

Solution: I then pulled in the actual transit stage column itself into the visual filter, filtered on that, and it worked a charm.