Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
scott_henderson
Icon for Helper II rankHelper II
3 years ago

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 ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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!