Fetch Metadata From Dashboards

[Anonymous]

Hi All,

I need to fetch the metadata information from power Bi dashboards, either from power bi desktop or service.

I need the following metadata information :-

- tables

- data souce 

- filters

- columns

- calculated measures or calculated columns

Thanks 

Sanchit

[Icey]

Hi @Anonymous ,

Power BI Desktop file stores many metadata information in it locally. Followings are two good blogs which could help you understand the structure of PBIX file and how to expose M Code and Query Metadata of Power BI (PBIX) File. 

What makes up a Power BI Desktop PBIX File

Exposing M Code and Query Metadata of Power BI (PBIX) File

Best Regards,

Icey

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

[Anonymous]

Hi @Icey 

Thanks for your response.

That was very helpful but i am looking for file where the field, table & data source level information along with lineage.

Regaards

Sanchit

[Icey]

Hi @Anonymous ,

You can download the PBIX file to local. Then follow these steps:

1. For data sources, you can get it from

• "Home" -> "Edit Queries" -> "Data source settings";
• Or, unzip the zip file and open "DataMashup", referring to What makes up a Power BI Desktop PBIX File.

2. For Tables, columns and Measures, you can get them through Power BI Helper.

You can also export them out to htm file.

Best Regards,

Icey

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