An MDX query may run slightly slower than an equivalent DAX query as MDX has slightly different query semantics, but regardless of the query language used all queries against tabular models are resolved against the in memory storage. This is incorrect, queries against tabular models NEVER run against on-disk storage. This appears to be running against disk rather than in-memory since it is running MDX instead of DAX? Thanks for any help! sql-server-analysis-services I am really hoping for a plug in or some other way for Excel to generate DAX queries instead of MDX. Power BI will come eventually but I have a large portion of users that prefer to live only in Excel. My question is what options are there for "end user" (no code) tools to efficiently query tabular models with DAX? My user base is all on Excel and I would like to build tabular models for them but the performance is severly lacking compared to the multidimensional counterpart. I know that Power BI generates DAX queries regardless of SSAS mode so I gues this isn't suprising. This appears to be running against disk rather than in-memory since it is running MDX instead of DAX? I tried the same thing from browsing the model in SSMS and it generates MDX as well.
It returns the correct answers and behaves as expected but I am surprised that it is sending MDX queries to the server. The SSAS server is 2019 and Excel is 2016.
I have a relatively small 57MB tabular model that I would like to query with Excel Pivot table connections.