Forum Discussion
Excel pivot on analysis server slow, same table selection in powerbi desktop is fast
My customer wants to continue using Excel pivot. We have a tabular model in azure analysis server. When making a pivot on 2 columns (1 from the fact, 1 from the dimension table), it is very slow an...
Hi,
Faced the same problem recently . Users have their's saved excel file(cube) working periodically .Suddenly out of nowhere,nobody can refresh excel connected to ssas tabular on-prem . Refreshing takes too much time and load analysis server RAM heavily . Anyone found soluton or workaround ?Thanks in advance
After several back and forth , i have found that the reason was custom format string of YoY% calculation in newly created time intelligence calculation group.