Create Pivot Tables connected to DAX Native Provider
Currently, Excel Pivot Tables connects to Analysis Services Tabular data models trough MSOLAP Provider which writes MDX queries back to Analysis Services.
MS Excel should be able to use the same provider as Power BI and Power View and natively write DAX queries back to SSAS with enhanced query performance.
Currently the only way to use DAX queries is to write a DAX query in the MDX query windows while importing data into Power Pivot, dramatically increasing the file size, duplicating the data into a new data model and having to recreate DAX measures available in SSAS into Power Pivot data model. Pivot Tables with connected Slicers and a Timeline increase even more the MDX statements and degrades performance.
This needs to happen! When you have more than one slicer connected to a Tabular datasource, the performance is terrible!
Also, can we get just a regular Table visual like Power BI has? This would be hugely helpful in Excel.
Micah McBride commented
Agreed on all counts. Thanks for the post.
Fernando Fajardo commented
Additional background and workaround available in the following Blog post:
Justin Sink commented
Power BI is great but excel has much wide usage. It would be nice if Excel can keep up with Power BI with native DAX