Showing results for 
Search instead for 
Did you mean: 
New Member

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


Super User
Super User

@BIGouders ,


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


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 ?





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


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:


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


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


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,



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors