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

pwrbiadm's avatar
pwrbiadm
Helper I
3 years ago

Can someone please provide the soultion to the issue "exceeded the available resources"?

 

I am unable to understand what is wrong? I don't have large DAX calculations. I have only added 4-6 more columns in one or two tables. My other visuals on the tabs on desktop has larger queries and measures. They all are running and refreshing just fine. I am having issue with just one visual. It doesn't make sense why with just one visual? 

Jeanxyz's avatar
Jeanxyz
Power Participant
2 years ago

Does the measure involves data from two fact tables? In most cases, DAX don't need to create a physical table to run the calculation, but when the data structure is complex, DAX has to create a physical table which can exceed the calculation capacity.