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

Rajiv's avatar
Rajiv
Advocate I
8 years ago

I am having the same issue. I have a function that picks the latest date and time out of 5 Mn rows. And then uses that against other rows to calculate the relative age which then becomes the basis of the period for the chosen metric. It works well on my PBIX file as my desktop has 32 GB RAM. Our On Premise Datagateway runs on a VM with 4 GB RAM. Is there a possibility that if I increase the RAM on the VM, it would work fine?

  • jl20's avatar
    jl20
    Helper IV
    8 years ago

    I'd be interested in this as well. We're running our data gateway on Azure. Does the memory on the data gateway even matter, given that the report is hosted in the PBI service?