Metadata for Pbix files

[sanchit_1610]

Hi All,

I am looking to get metadata information for the pbix files.

I need the following metadata information :-

- tables

- data souce 

- filters

- columns

- calculated measures or calculated columns

 

Thanks 

Sanchit

parry2k 

Greg_Deckler

[v-lili6-msft · Accepted solution]

hi @sanchit_1610 

Please refer to this blog:

What makes up a Power bi desktop pbix file

Regards,

Lin

[sanchit_1610]

Hi @v-lili6-msft 

That was helpful. But can we find all the information in one file and also have a lineage i.e from the calculated field we can get all associated fields and from that the data source to database and Schema.

Regards

Sanchit

[v-lili6-msft]

hi @sanchit_1610 

They are stored in different subfile of PBIX file, unless you open pbix file in power bi desktop.

Regards,

Lin

[mwegener]

Hi @sanchit_1610 ,

look at this.

https://www.thebiccountant.com/2019/09/14/compare-power-bi-files-with-power-bi-comparer-tool/

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[d_gosbell]

Another option is the Vertipaq Analyzer tool https://www.sqlbi.com/tools/vertipaq-analyzer/