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...
Hello,
I am seeing couple of cases which is releated to AAS & SSAS, which is pointing to similar issue and manage to fix by doing modification to the server setting, please check this doc which I have created to fix the issue.
https://kingfishertechtips.in/calculation-items-error-server-out-of-memory/