Forum Discussion

Nishantjain's avatar
Nishantjain
Icon for Continued Contributor rankContinued Contributor
5 years ago

Calculation Groups & Analyze in Excel

Hi,   I was wondering if anyone has experieced very poor performance when using calculation groups with analyze in excel.    A matrix visual in Power BI service that takes about 5 seconds to refr...
Need Help
kaisrec's avatar
kaisrec
Icon for Advocate I rankAdvocate I
2 years ago

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