03-20-2017 07:11 PM
I didn't realise you could use DAX Studio for DMV's but I guess that makes sence. I normally do my DMV work in SSMS, (or in Power BI Desktop itself) and that is a great article by @MattAllington
Could you have a further explanation on how to do that in Power BI Desktop. I know the DMVs in SQL Server, Just wondering how to do that in Power BI Desktop. Thanks in advance.
03-20-2017 07:34 PM
Hmmm, maybe not.
You used to be able to unzip Power Pivot models and suck the formulas out of the xml files, but they have compressed/encrypted the data so not so straight forward.
04-03-2017 10:35 AM
I found a better solution, following that video: https://www.youtube.com/watch?v=rYlIp1PrBcA
Basically, in the DAX Studio, you click on MDSCHEMA_MEASURES.
You get an SQL, execute it and you got a lot of details on your measures.
That you can of course export directly to Excel.
Is there a way to do the reverse of this? I want to load the measures into the PBIX file from SQL.
I'm thinking of creating a measure library in SQL that would give all the different developers access to the list of measures. It also means measures can be edited and updated across multiple PBIX files.