Forum Discussion
This visual has exceeded the available resources
Hi,
I created and published a report. I can view the report without any issue but my colleagues received the mentioned error on some visuals. Any ideas on this situation? Thank you.
Resources Exceeded
This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.
Please try again later or contact support. If you contact support, please provide these details.
More details: The XML for Analysis request timed out before it was completed. Timeout value: 225 sec.
6 Replies
scott_hendersonHelper II
Sounds like bad model or bad dax..... What capacity are you running, or licence type, could simply be running out of memory ?
scott_henderson Thanks for your reply.
We are using Pro License.
Some colleagues can view that matrix but others will receive the error. May I know is bad model or bad dax may lead to this behavior? Thank you!
- scott_henderson
Can be either bad model or bad dax or an element of both, do you have a sample file i can check ?
scott_henderson Thank you for your help.
The matrix has 6 dax with the below pattern:
XXX = CALCULATE(DISTINCTCOUNT(
'application'[id]),
'application'[tag] in {"AAA", "BBB", "CCC", "DDD"} && 'application'[indicator] = "L"
)And the matrix is using one table.
Thanks!
- scott_henderson
Yes, this could be your issue, if you remove say 3 of these distinct counts and republish, do the users still have the issue ?
Would really need a pbix to check and advise more ?scott_henderson Thank you for your suggestion. I tried to remove 3 of those measures but the problem still exist.
You may download the sample pbix here: sample.pbix
Thanks again!