Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |