David Cadman on 13 May 2016 16:41:32
Currently you have to click Advanced Editor and edit the Source on one line, e.g.
"Source = AnalysisServices.Database("Dbase", "Transactions", [Query="EVALUATE#(lf)SUMMARIZE(#(lf)...."
It would be far easier to edit the query in the original "Import Data - MDX or DAX Query (Optional)" box as an intented string on multiple rows.
- Comments (4)
RE: Edit Analysis Services (MDX or DAX) in orginal format
While technically, it looks like we can adjust using the 'Advanced Editor" it is not easy.
We can do this if the query is an SQL. But not sure why there is no way to edit using standard MDX/DAX.
RE: Edit Analysis Services (MDX or DAX) in orginal format
This is a must have feature. Every report tool have this!! Actually, the user need to create a new query, and recreate every single visual with the fields of this new query. This is so laborious to do every time we need to add a field
RE: Edit Analysis Services (MDX or DAX) in orginal format
This is 100% needed... I believe people has not yet used so much the MDX feature against SSAS MD ddbb, therefore they haven't realized how annoying is to edit the MDX... please more votes!! :)
RE: Edit Analysis Services (MDX or DAX) in orginal format
I'm surprised this has only 1 vote... in the current version of Power BI is quite challenging to change the MDX if you want to include a particular member in a SELECT