Extracting renamed visual field name from power bi

[BC123]

Hi all,

Im currently building a power bi dictionary that pulls relevant measure data from all our reports. Im using the dmv query $SYSTEM.TMSCHEMA_MEASURES.

The issue is we often rename measures when used in visuals for clarity. Is there anyway to extract the renamed names for these fields?

For example, is there anyway to extract "Specific Spend" from below and have it linked with the measure metadata?

Thanks!

[Greg_Deckler]

@BC123 I checked if PowerOps could provide this information. Sadly it cannot currently. However, I reached out to the developers at TruViz and they are planning on including this functionality in the next release.

[AnalyticsWizard]

@BC123 

To extract the renamed names for fields in Power BI, especially when they have been altered for clarity in visuals, you can consider the following approach:

1. Report.json File: Save your Power BI report in the .pbix format, and then extract the report.json file from it. This file contains the visual level names and their corresponding actual names, which can help you l...1.

2. DMV Queries: While DMV queries like $SYSTEM.TMSCHEMA_MEASURES provide measure metadata, they may not directly reveal the renamed visual names. However, you can explore other DMV queries that might offer this information, such as $SYSTEM.DISCOV...2.

3. Power BI Service: If your reports are hosted on Power BI Service, you can sync your reports to Azure...1.

Remember, after retrieving the renamed field names, you’ll need to establish a method to link them back to the measure metadata, which might involve some custom scripting or additional data processing steps. 

[tharunkumarRTK]

@BC123 

This is an intresting question. I dont think you will be able to get that visual level names from DMVs. One possible way that you can look into is the report.json file. Save your report as PBIP file format and in the report.json file you will be able to see the visual level names and the correcposnding actual name. 

For your reference:

If I look at the report json file:

Incase if your reports are in power bi service then you can sync your reports to azure repos and extract from there.

Hope this answers your question.

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun