Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
gooranga1
Power Participant
Power Participant

MDX script not being recognised in new version of power bi

We have just updated to the latest version of powerbi desktop 2.35.4399.38. 

 

However this version doesn't allow or doesn't recognise mdx scripts as an import. All our pbix files are in the main using a connection to ssas databases with a pre-defined mdx script. These all worked fine but now if you try to edit an existing one it removes all the columns.

 

If you try to create a new data source and paste in the mdx it simply moves to the next page as if you haven't supplied a script and then you pick measures and dimensions? Anyone else experiencing this?mdxproblem.PNGnavigator.PNG

4 REPLIES 4
gooranga1
Power Participant
Power Participant

I have found the previous msi for power bi desktop so to test my sanity I have re-installed the previous version. When I go to edit an mdx query it edits it fine. Re-installed the new version and it collapses into an unsightly pile.... See screenshots below. Old version spins a for a bit then takes you back to your dataset. New version spins and returns nothing. Totally useless to us.

 

It no longer accepts mdx queries, I suppose I could edit the query in advanced editor to make it work which really is not want I want to do.

 

I think I am going to switch to the old version, this version is pants. Hopefully I can restore the old versions of the pbix files I saved in the new verision from our source control as once saved in the new version there is no going back!

New VersionNew VersionOriginal VersionOriginal Version

@gooranga1

 

I reproduced same issue as yours in May Update Power BI Desktop. We have reported it internally.

 

Regards,

Hi @Simon_Hou any updates?

Hi @v-sihou-msft do you know of any timescales to get this working again?

 

Thanks

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.