Calculation Groups & Analyze in Excel

Question

Hi,&nbsp;I was wondering if anyone has experieced very poor performance when using calculation groups with analyze in excel.&nbsp;&nbsp;A matrix visual in Power BI service that takes about 5 seconds to refresh takes more than a minute when exactly the same view is created in Excel Pivot table using Analyze in Excel.&nbsp;&nbsp;It seems that calculation groups aren't optimised for Analyze in Excel, unless I am doing something wrong&nbsp;ThanksNishant

v-easonf-msft · Answer

Hi,&nbsp;Nishantjain&nbsp;
Please refer to this document about Analyze in excel.
https://www.sqlbi.com/articles/why-reports-obtained-with-analyze-in-excel-can-be-slower/&nbsp;
&nbsp;
Best Regards,Community Support Team _ Eason

kaisrec · Answer

Excel produces MDX queries, on the other hand, Power BI produces DAX queries towards the Power BI dataset.
Moreover, unlike MDX queries, DAX queries are optimized by the use of a fusion process which includes in a single storage engine request

Forum Discussion

Calculation Groups & Analyze in Excel

2 Replies

Related content

Calculation Groups help

Fabric & Azure Data User Group Program Requirements & Benefits

Using Visual Calculation on a Calculated Group with Multiple Calculated Items

Calculate growth based on calculation group item

Dynamic Calculation Group Item