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

Jeanxyz's avatar
Jeanxyz
Power Participant
2 years ago

This explains the error but not help solving the problem. I happen to notice one of my DAX measure used switch function, that consumes lots of capacity:

Reporting Amount Base_PL = SWITCH([Selected Currency],1,[Group Currency Amount Base_PL (EUR)],2,[Company Currency Amount Base_PL],3,[Budget Currency Amount Base_PL (EUR)],4,[USD Amount Base_PL (USD)])

to reduce the resource need, I stop using the switch function and use the sub measures directly.