Power Query Management Studio reloaded: Now supports MDX

Very happy to see that my Power Query Management Studio isn’t just perceived nerdy but useful as well 🙂 Thanks to Dusty for his nice review.

So let’s push it a bit further and add some MDX functions to it that cannot be done by DMVs:

  • get a list of all unique fields used in a specific MDX query
  • translate your code to a different cube using a simple field-translation table

How to use this for MDX:

In sheet “Source” copy your code into cell A2. Refresh the queries and have a look at sheet “List” where you find your unique fields in column A.

You can now fill in the field names of your new cube into column D, refresh again and fetch your translated code from cell F2.

MDXCodeTranslationManager.xlsx

 

Enjoy & stay queryious 🙂

 

Comment (1) Write a comment

Leave a Reply