Exporting Relationship Model

[BIGouders]

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 and Column Ranges, can be extacted using Interops Assemblies or VBA code.

[amitchandak]

@BIGouders ,

You have an option to analyze in excel. See if that can fit your requirements.  May not be the same stuff you wanted

https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel

[BIGouders]

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]

Hi @BIGouders ,

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

[BIGouders]

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