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.
POWER BI Service with Tabular Visualization Report Performance - SSAS multidimensional
I have a multidimensional molap cube with 15 measures and ~15 dimensions.
The cube is browsed from POWER BI service, and the SSAS server use an "on premises data gateway" with the memory of 24GB.
When I browse a table visualization report with value contains of 1 measure and 3 attributes from different dimensions, the result seems good that I can have the report appeared.
But when I try to add more (another) attributes, the report just keep loading (loading forever) and the memory in the ssas server is used until exhausted.
Please advise what should I do when I face that issue?
Note :
I have tried to browse the SSAS with the same measures and dimensions in SSMS the report is appeared.
I saw 2 DAX query from power bi when I did profiling on SSAS. The first query got error “The operation has been cancelled because there is not enough memory available for the application..”
Hi @reynaldichen,
Have you checked this blog which describes a similar issue?
Regards,
Yuliana Gu
Thanks for the link, but my memory used until 99% so I think it is not about the memory configuration.
Regards,
Reynaldi Chen
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.