Problem importing MDX from SSAS cube

[Phil_Seamark]

Downloaded the May update of Power BI Desktop this morning and it seems I can no longer import custom MDX code as a data source.

If I paste in a simple MDX statement in the "MDX or DAX (optional)" text area, the next screen just shows the cube navigator screen and doesn't load the results of the query.

[gooranga1]

Has anyone got a response to this?

I finally got an email last night asking me to record the steps I was taking using Steps Recorder and send it to them even though on these posts it's been stated the problem has been replicated internally???

I went through the rigmarole of installing and de-installing the new version to screen shot the problem to send to them.

Has anyone else had any joy with this issue?

[MaciejSowa]

I had the same issue. Latest download 2.36.4434.362 fixed it. I can apply MDX query in import data mode.

[ksnayadi]

I have the same issue this morning after updating the desktop - the MDX query that I had in my reports are disappearing after I click the OK button on the Source/Query Dialog window and in turn it takes out the data set that was previously loaded with the MDX query. I use an Analysis Server/Database for my Data Source.

[Phil_Seamark]

The work around I am using in the meantime is to edit the M code directly using the advanced editor in the Power Query editor. 

Hopefully they update the product soon.

If you revert to the April version of Power BI, it won't open any PBIX file that has been saved using the May version.

[ksnayadi]

Thank you, I will try that. How did you revert to the previous version of the Desktop?

[Phil_Seamark]

I still had the installer in my download folder from when I downloaded it.  Keeping them from now on just in case I need to roll back for other reasons. 🙂

[v-sihou-msft]

@Phil_Seamark

I reproduced same issue as yours. It seems to be a potential bug, please submit an Idea: https://ideas.powerbi.com/forums/265200-power-bi. We will also report internally.

Regards,

[Seth_C_Bauer]

@v-sihou-msft I noticed there is now an "Issues" forum listed at the top of the Community main page... Should we be using that for bugs, or what everyone assumes is just the forum for feature requests that you mention? Are they both monitored, or one over the other?

https://ideas.powerbi.com/forums/360879-issues

@Phil_Seamark - cc

[v-sihou-msft]

@Seth_C_Bauer@Phil_Seamark

Sorry for my mistake in previous post. As I comfirmed, "Ideas" is for feature request only. If you encountered any bugs/issues, just post it on forum, we will test and report them via internal channel.

Regards,

[ksnayadi]

The issue I raised is pretty severe - not being able to work on queries is essentially stopping all of my development work. I am surprised that PowerBI team is taking this long to get a fix in. for that

[Phil_Seamark]

I thought ideas were for feature requests rather than reporting/managing bug fixes.

[ksnayadi]

I have already reported it there and also sent a frown from my desktop  - I have got a response but no fix yet.