Is there a way to retrieve all measures?

[Anonymous]

Hello

Is there a way to retrieve all measures from one pbix file and export or copy them to a txt file?

That would help for further documentation and as well mass changes if needed.

Cheers.

[Phil_Seamark · Accepted solution]

Hi @Anonymous,

Yes there is.  You can run a DMV query against the Tabular cube.

Essentially you need to connect to your Power BI Desktop instance from a tool such AS Sql Server Management Studio (or MDX Studio) and issue the following Query

SELECT [CATALOG_NAME] as [DATABASE],

    CUBE_NAME AS [CUBE],[MEASUREGROUP_NAME] AS [FOLDER],[MEASURE_CAPTION] AS [MEASURE],

    [MEASURE_IS_VISIBLE]

FROM $SYSTEM.MDSCHEMA_MEASURES

This will output information on your measures

[Phil_Seamark · Accepted solution]

Hi @Anonymous,

Yes there is.  You can run a DMV query against the Tabular cube.

Essentially you need to connect to your Power BI Desktop instance from a tool such AS Sql Server Management Studio (or MDX Studio) and issue the following Query

SELECT [CATALOG_NAME] as [DATABASE],

    CUBE_NAME AS [CUBE],[MEASUREGROUP_NAME] AS [FOLDER],[MEASURE_CAPTION] AS [MEASURE],

    [MEASURE_IS_VISIBLE]

FROM $SYSTEM.MDSCHEMA_MEASURES

This will output information on your measures

[Anonymous]

Hi Phil, 

This is very helpful. I wonder if DAX Studio can acheive the same result.

Can I use the same query to extract all measures at once and perhaps copy to another dataset to be used in PBI?

Thanks!