Reply
Moderator
Posts: 2,173
Registered: ‎03-06-2016

Re: Is there a way to retrieve all measures?


Phil_Seamark wrote:

Hi @Sean.

 

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

 

 


@Phil_Seamark

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.

Highlighted
Super Contributor
Posts: 1,441
Registered: ‎11-29-2015

Re: Is there a way to retrieve all measures?

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.  

Frequent Visitor
Posts: 6
Registered: ‎01-25-2017

Re: Is there a way to retrieve all measures?

Hello 

 

I found a better solution, following that video: https://www.youtube.com/watch?v=rYlIp1PrBcA

 

2017-04-03 19_25_13-DaxStudio - 2.6.0.png

 

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.

 

Cheers