Analyze in Excel using DAX
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 navigate a PBI model using Excel is great, and helps get stubborn uses on to using curated data sets without having to get them to make the even bigger jump to moving away from their beloved excel.
However, we're noticing performance issues when MDX queries are hitting the model. If I write a query in DAX I can return my desired results in around 2 seconds, where as it can be minutes when MDX is used.
Is there any scope/desire for the Analyze in Excel functionality to be re-engineered to query the PBI data model using DAX queries instead of MDX?