Skip to main content

Power BI

Needs Votes

Easily export relationships between tables into a Spreadsheet or table

Vote (331) Share
Phil Boguszewski's profile image

Phil Boguszewski on 01 Jul 2016 20:18:26

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

Comments (37)
Phil Boguszewski's profile image Profile Picture

Lars Petter Skjærholt on 21 Aug 2024 07:02:57

RE: Easily export relationships between tables into a Spreadsheet or table

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

Phil Boguszewski's profile image Profile Picture

Carsten Denmark on 12 Sep 2023 06:32:51

RE: Easily export relationships between tables into a Spreadsheet or table

Yes, Please add this feature

Phil Boguszewski's profile image Profile Picture

Richard Mabjish on 24 May 2023 15:44:06

RE: Easily export relationships between tables into a Spreadsheet or table

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

Phil Boguszewski's profile image Profile Picture

Tejiri Afe on 20 Jul 2022 07:55:58

RE: Easily export relationships between tables into a Spreadsheet or table

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

Phil Boguszewski's profile image Profile Picture

Amr Guenena on 18 May 2022 05:17:00

RE: Easily export relationships between tables into a Spreadsheet or table

please add this feature, it is much needed

Phil Boguszewski's profile image Profile Picture

Lewis Prynne on 23 Mar 2022 11:32:22

RE: Easily export relationships between tables into a Spreadsheet or table

Agreed, it would be great to get some export options.A temporary process, a list of relationship can be pulled quite easily by:Connecting Tabular EditorExpand the 'Relationship' folder in the left-hand navigation paneSelect all the relationships and Ctrl+CPaste into Notepad and save as relationship.jsonOpen Excel > Data > Get Data > From File > JSON and navigate to your new relationship.jsonTIP: Do this for multiple version of a model to quickly identify difference/changes.

Phil Boguszewski's profile image Profile Picture

Lon Kress on 04 Feb 2022 20:15:44

RE: Easily export relationships between tables into a Spreadsheet or table

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.

Phil Boguszewski's profile image Profile Picture

Jason Rueckert on 01 Feb 2022 19:35:16

RE: Easily export relationships between tables into a Spreadsheet or table

This feature could really be helpful in giving a PDF version of the model to my developers to help them better understand the relationships.

Phil Boguszewski's profile image Profile Picture

Luigi R on 19 Jul 2020 14:03:17

RE: Easily export relationships between tables into a Spreadsheet or table

Please add the functionality ASAP.
Have the model in front of you when creating measurements etc. it is absolutely useful and necessary.
For the direct print option, very useful i.e. as a working copy, please also add the possibility to change the formatting, at least the background color (ultimately remove it).

Phil Boguszewski's profile image Profile Picture

Gina P on 15 Jul 2020 20:45:17

RE: Easily export relationships between tables into a Spreadsheet or table

Feature to export it to Visio?