Easily export relationships between tables into a Spreadsheet or table

[PhilB]

It would be really handy if there was a way to export the relationships between your database tables into a spreadsheet or table. for me i keep track of a lot of things in OneNote and entering all the tables and their relationships becomes more unmanagable once you have a lot of data. If a user could just export or even print a map of the relationships for easier reference. Thanks

[lon_kress]

Customers have been pleading for this capability -- in this request as well as a dozen others -- for going on 6 years. Kindly ask that the developers of Power BI please listen and respond.

[fbcideas_migusr]

Agreed, it would be great to get some export options.

A temporary process, a list of relationship can be pulled quite easily by:

1. Connecting Tabular Editor
2. Expand the 'Relationship' folder in the left-hand navigation pane
3. Select all the relationships and Ctrl+C
4. Paste into Notepad and save as relationship.json
5. Open Excel > Data > Get Data > From File > JSON and navigate to your new relationship.json

TIP: Do this for multiple version of a model to quickly identify difference/changes.

[Amr_Guenena]

please add this feature, it is much needed

[Tejiri_Afe]

Why we still need to plead for such a basic functionality is beyond me. The team behind this software should attend to this suggestion because it is a very much needed feature

[Richard_Mabjish]

ability to export to pdf, word doc and to an image.

[fbcideas_migusr]

Yes, Please add this feature

[lars_petter_skj]

Not only export of relationships is dearly missed.

Not to be able to make a system report for the report views you make on the canvas is a huge disadvantage.

Which field from which Table. And which field is related to which field in which Table that is related to .............

What is the definition for the field. Is it calculated? What is the script?

A system report on that level is appreciated.

The above mentioned applies also for imports made with M