Hi @Prabu Chandran ,
In most cases, Excel always perform poorly with Tabular Models.Excel Pivot Tables query Tabular SSAS using MDX, and sometimes the MDX they generate is not ideal. And response times can be particularly slow where the tables have lots of columns and are large in size.
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,
Joy
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.