Map all visual field names to corresponding measure and columns from the data model.

[EduardD]

Hi folks, Is there a way to extract from PBIX report list of all field names used in the visuals and corresponding data model columns/measures?
I need something like this in CSV/Excel:
ReportPage, VisualName or Type, FieldName in visual, TableInDatamodel, ColumnName, MeasureName.
Thank you in advance

[Alex87 · Accepted solution]

Have you tried using https://www.pbiexplorer.com/ ? It is the only tool I can think of that gets close to what you want to achieve.

[v-jianpeng-msft · Accepted solution]

Thanks @Alex87 

Hi, @EduardD 

You can use the INFO functions provided by Power BI, which you need to use in the DAX query view, as shown in the following image:

INFO.FUNCTIONS – DAX Guide

If you don't know how to enable this feature, you can follow these steps:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Alex87 · Accepted solution]

Have you tried using https://www.pbiexplorer.com/ ? It is the only tool I can think of that gets close to what you want to achieve.