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.
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.