Forum Discussion
Solved
Analyze in excel - refresh take a long time
Every change in matrix takes 4-5 seconds to come and the same in case I have to replace or remove a set of matrix. and this will make this beautiful tool so slow, pls suggest a way where refresh tim...
Hi amanjhanwar_02 ,
You can refer to this artilce.
Possible optimizations
In order to improve the performance of an Excel report based on a PivotTable, consider the following best practices:
- Only in SQL Server Analysis Services: Reducing the number of measures included in a PivotTable. (No longer required in Power BI and Azure Analysis Services since October 2020).
- Optimizing the performance of the measures used in a PivotTable.
- Avoiding any CallbackDataID especially in measures that are referenced multiple times in the same report.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi All,
In Analyze in excel Pivot user have to to wait 5-10 seconds when they slice and dice the each filters, is there any other way where I can reduce this time or where I can change all slice and dice once and then OLAP query runs at once only.
Pl help on this.