When users connect to a data model using Analyze in Excel, the model is queried using MDX. However, all the performance tuning tools available are geared towards DAX. I think the ability to navigat...
many users still use excel to access data from tabular models. I have personally observed several ocasions where MDX generated in excel pivot tables underperforms when compared to DAX generated in power BI table or matrix visual with the same output..
some cases are as described: from seconds with dax to minutes with MDX.
It would be great if Microsoft reworked their analyse in Excel to use dax or optimize the MDX generated.
