Forum Discussion

samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
10 years ago
Solved

Dax editor

On Friday I built a data model in powerbi desktop and published the draft version to powered. On Monday I did a little bit more work and locally saved the work I had done. I have since had some calam...
Need Help
  • samdthompson's avatar
    samdthompson
    10 years ago

    Thanks for all the ideas guys, looks like this is a no solution problem at the moment, tried the DVM query but did not work either. After a couple of gins last night I feel much happier about rebuilding all my work.

PowerDAX's avatar
PowerDAX
Icon for Resolver III rankResolver III
10 years ago

Pretty nifty way to work around this with the new analyze in excel option.  Connect to powerbi.com and select the analyze in Excel feature.  Follow the instructions here:  http://www.sqlbi.com/articles/import-data-from-tabular-model-in-excel-using-a-dax-query/ to change the data connection from a model type to a query type and pass in the following DMV query to extract the definition of your metrics:

 

SELECT [MEMBER_UNIQUE_NAME] AS [CALCULATED_MEASURE],
    [MEMBER_CAPTION] AS [CAPTION],
    [EXPRESSION]
FROM $system.MDSCHEMA_MEMBERS
WHERE CUBE_NAME ='Adventure Works'
AND [MEMBER_TYPE]=4