Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Fetch Metadata From Dashboards

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

Dataflow
Need Help

3 Replies

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Icey
        Community Support
        6 years ago

        Hi Anonymous ,

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

        1. For data sources, you can get it from

         

        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.