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
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