Forum Discussion
Metadata for Pbix files
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
5 Replies
- mwegenerMost Valuable Professional
Hi Anonymous ,
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_gosbellSuper User
Another option is the Vertipaq Analyzer tool https://www.sqlbi.com/tools/vertipaq-analyzer/
- v-lili6-msftCommunity Support
- AnonymousNot applicable
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-msftCommunity Support
hi Anonymous
They are stored in different subfile of PBIX file, unless you open pbix file in power bi desktop.
Regards,
Lin