Forum Discussion

Frequent Visitor

6 years ago

MDX Compatibility = 2 OLAP SSAS Excel Power BI Desktop

Good afternoon, How to configure a connection from Excel/Power BI to Analysis Services with MDX Compatibility = 2? Google does not help, as if in no way, because Excel/Power BI sets MDX Compatibi...

Need Help

amitchandak

Super User

6 years ago

by-myselff ,

See if these can help

https://support.office.com/en-us/article/analysis-services-mdx-query-designer-power-pivot-30ab91f9-82a6-4f95-a5ec-2b6b7ab5cbcf

https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/mdx-query-fundamentals-analysis-services?view=asallproducts-allversions

https://blog.crossjoin.co.uk/2015/07/29/running-your-own-mdx-and-dax-queries-in-power-bi-desktop/

https://community.powerbi.com/t5/Desktop/limit-SSAS-data-import-through-MDX-DAX-query/td-p/700566

https://community.powerbi.com/t5/Desktop/How-to-change-MDX-query-from-Desktop-to-SSAS-live-connection/td-p/169163

Forum Discussion

MDX Compatibility = 2 OLAP SSAS Excel Power BI Desktop

Related content

Compatibility with Desktop May 2024

Power BI DeskTop Connecting to Excel

Compatibility between Power BI Desktop 2.154.956.0 and Power BI Report Server 1.25.9558.32914

Power BI Desktop on ARM (Snapdragon) – “Error Fetching Data for This Visual” + Compatibility Concern

Excel desktop