Forum Discussion
visual has exceeded available resources
- 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
Also having this issue. Does not make sense. Need to understand limits better as it is turning a supposedly enterprise-level tool into a bear for certain critical tasks within my relatively-small dataset.
I am having the same issues. The dataset is not huge but I do have a number of measures becasue I need the model to be dynamic. The model works on the desktop (slow but works), but in the serivce it sometimes works and sometimes crashes. Also, I have noticed that the "spinning wheel" that used to tell me if the system was still calculating, is now gone and so I have no idea when all the calculations are compleded (I assume it vanishes when a model is nearing the resource limit). It's quite frustrating becasue you start to think that the model is stuck and then all of a sudden the data in refreshes.
Is this all becasue we are not signed up to Premium Capacity? Other than major corporations, who can afford Premium Capacity at $4,000/month (or more)??? And then you start looking at Microsoft's pricing model for usage you start to wonder how anyone can really understand what their monthly bill is ever going to be. I call it the "Rube Goldberg Pricing Model". Very frustrating.
- OliveiraThiago7 years agoHelper I
Hello,
Would someone confirm if this is a Premium / Pro issue? Either I change my DAX or I don't know what to do. It seems that every time I upload my data I am going to see this issue.
I just hope Microsoft bring us a solution.
Cheers
- gooranga17 years agoPower Participant
I got this error today. On a relatively small set of data it is only a year but there are some complicated DAX expressions on it.
It seems the last straw was adding a PERCENTILEX.INC in a matrix. It won't even show 1 days worth of data which is only about 20 rows in the matrix. the table itself is only 436 rows.