Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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