Forum Discussion
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...
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