Forum Discussion

kaarel's avatar
kaarel
Icon for Resolver I rankResolver I
9 years ago

Large Table and Matrix resultset crashes/slow SSAS multidimensional performance

Hi!   I stumbled upon a problem with SSAS live multidimensional connectivity when there are many columns in Table or Matrix with large resultset, then it crashes or is very slow. It eats up all the...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

kaarel This help me a lot!

 

I don't why, this is still happening.

I had to disable the "Totals", and then it was really faster!

It didn't fixed yet?

 

v-sihou-msft  can you help us?

 

Thank!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    kaarel wrote:

    SQL Analysis Services 2019 already has a fix. Once Power BI Desktop update comes out we should be fine. Only Microsoft can answer when.

     

    https://powerbi.microsoft.com/en-us/blog/whats-new-for-sql-server-2019-analysis-services-rc1/

     

    Oh, ok!

    Thanks for let me know, I'm new to Analysis Services. Also thinking, what people and companies are using without OLAP Cube? Is there better option?

    I'm using SQL Analysis Services 2017, I already disable the totals for that. If you have any more tips, please also let me know.

     

    Really thank you!!