Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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.
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!
Solved! Go to 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...
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...
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 46 | |
| 43 | |
| 39 | |
| 19 | |
| 15 |
| User | Count |
|---|---|
| 68 | |
| 68 | |
| 31 | |
| 27 | |
| 24 |