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...
This is a much needed feature we have been waiting for. Often DAX queries can perform 10x or better than MDX in some cases. We have resorted to making users run queries in Power BI reports and manually export them because the MDX from Excel to get the same data can take so long in some cases. Yes there are things we can do to the model and performance tuning but when the result is the exact same data but taking 10x or more time using MDX then something needs to be done.
