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.