Cataloguing the measures and filters used in visualisations/reports

[Miles_Gawthorp]

Looking at a suite of reports which have been built up over a number of years, I need to catalogue the measures and filters etc used in the various visualisations and reports to see how much commonality there is with the aim of knowing if we change a measure in the source cube, which reports/visualisations will be affected. Is there a way to automate this or shortcut? Or do I need to manually open each visualisation?

[v-diye-msft · Accepted solution]

Hi @Miles_Gawthorp 

You can retrieve all the measures by running 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.

But for retrieve all the filters info. I doubt it's not possible.

[amitchandak]

@Miles_Gawthorp ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Miles_Gawthorp]

I have a report with 4 visualisations, e.g. a bar chart, a gauge, a clustered column chart with line etc.

To populate those visualisations I need a value, an axis, a legend etc.

I need to create a document which lists as much information about the report as I can, i.e. the cube measure used in the value, the attribute used in the legend etc.

The resulting document is a reference guide for future development. e.g. if we change the way a measure is calculated, which reports have that measure and will therefore be affected.