The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 Compatibility = 1 by default
Thanks!
Hi @by-myselff ,
Yes, MDX Compatibility is set as 1 by default.
I found a way to configure it, refer to this document: https://docs.microsoft.com/en-us/analysis-services/instances/connection-string-properties-analysis-s...
The default ADOMD.NET connection string in Excel specifies the data provider, server, database name, Windows integrated security. The MDX Compatibility level is always set to 1. Although you can change the value for the current session, Excel will reset MDX Compatibility to1 when the file is next opened.
Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Adventure Works DW 2008R2;Data Source=AW-SRV01;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error
I saw it and thought there is a different solution
But thank you!
See if these can help
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
81 | |
62 | |
54 |
User | Count |
---|---|
246 | |
119 | |
114 | |
87 | |
70 |