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...
While Excel is a popular choice for business data analysis, using it with a Power BI semantic model currently faces performance challenges. This is due to the reliance on MDX queries, which are not optimized for Power BI. To address this, it's critical to prioritize the development and release of an Analyze in Excel Add-in that utilizes DAX queries instead. This will significantly enhance performance and provide a more efficient solution for users.
