Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Exporting Relationship Model

Greetings User(s), I wonder, if it is possible to extract metadata such as the relationship model out of PowerBI destkop similar to how the metadata of an MS Excel file, such as number of Worksheets...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greetings Amitchandak,

And thanks for your direction to do more research on the subject.

Referring to your link, it mentions that in order to use the Analyze in Excel feature requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license. Unfortunatly we are using PowerBI Desktop.

So when a PowerBI data analyst models the relationship among tables and introduces new columns not present in the underlying data sets, how can this metadata be extracted from PowerBI otherwise then maintaining a design document manually ?

 

Regards,

BIGouders

 

PS: Thanks to all who can contribute on answering the question 🙂

 

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Based on my search, you cannot directly extract the data model from power bi desktop, but you can connect to this data model through Dax studio.

     

    If you just want to export metadata, you can refer to the third - party article: https://xxlbi.com/blog/dax-studio-export-all-data/

     

    The DataModel file in the pbix file stores the data model. It is  your Power BI In-Memory Analysis Services model. But this file can only be used by power bi.

     

    For more details, please refer to third – party blog https://www.fourmoo.com/2017/05/02/what-makes-up-a-power-bi-desktop-pbix-file/

     

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

     

    Best Regards,

    Dedmon Dai

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Greetings Dedmon Dai,

      Thanks for sharing your knowledge. I checked out your links and the blog that describes how to export data from PowerBI using DAX Studio is very promising, since it states "[...]Note that all the names will be exactly as they are in the data model, including spaces[...]".

      Thanks a Lot,

      BIGouders