Resources Exceeded issue after upgrade to SSAS 2022

[serjdag]

Hello everyone,

We are testing migration from SSAS 2019 to 2022. When connected to a SSAS Tabular model on 2022, we get an issue with simple PowerBI desktop request. 

• Resources Exceeded. This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.

Same works perfect with SSAS 2019 as a source. Same request works perfect in Excel when connected to both 2019 and 2022.

I see that there are a lot of topics with comments to optimize the query, but the query here is really simple and it works for 2019. I believe that something is differend with SSAS 2022 or how PowerBI desktop works with SSAS 2022.

Any ideas will be appreciated.

Thanks!

[serjdag · Accepted solution]

The limits were set to custom and 0 for memory and 0 for size (that means unlimited).

Thank solved the issue.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-set-visual-query-limits#considerat...