cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
reynaldichen Frequent Visitor
Frequent Visitor

POWER BI Service with Tabular Visualization Report Performance - SSAS multidimensional

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..”

2 REPLIES 2
Microsoft v-yulgu-msft
Microsoft

Re: POWER BI Service with Tabular Visualization Report Performance - SSAS multidimensional

Hi @reynaldichen,

 

Have you checked this blog which describes a similar issue?

SSAS error “The operation has been cancelled because there is not enough memory for the application”...

 

Regards,
Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
reynaldichen Frequent Visitor
Frequent Visitor

Re: POWER BI Service with Tabular Visualization Report Performance - SSAS multidimensional

Hi @v-yulgu-msft

 

Thanks for the link, but my memory used until 99% so I think it is not about the memory configuration.

 

Regards,

Reynaldi Chen 

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)