Power BI

Needs Votes

Easily export relationships between tables into a Spreadsheet or table

Vote (221)

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 (29)

Comments (29)

be459118 d8d9-4d45-96ae-6b4f292445d6 on 05 Jul 2020 23:49:28

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

I was quite surprised to learn that this is (still) not possible. I tried a simply copy-past of the data in the RelationsShips table to Excel, but that failed... In my opinion, this should be standard functionality ASAP.
Did anyone find a workaround?

b868b6c8 487c-49d5-b8d6-2856029a426c on 05 Jul 2020 23:45:52

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

Please add this. We need it to be able to discuss future links to other sources and for documentation. We can't live without!!

c71e533c 79ef-4139-ade0-bbd932299325 on 05 Jul 2020 23:45:01

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

Agreed. Our number of tables is getting large and this would be helpful for distributing to the development team.

f7476791 316c-4332-b01a-501791df830f on 05 Jul 2020 23:44:44

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

Yes! The ability to generate a PDF of the Relationships View would be very helpful. There is a point when working with many tables that they don't all fit on the screen, making a big-picture audit very difficult.

487ee6ab 6de0-488f-b94b-68928d7d246b on 05 Jul 2020 23:42:06

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

when this is coming! BUMP!

411a60ba 5540-46c4-9efc-ef56c25ae52b on 05 Jul 2020 23:38:51

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

Export to Visio,, and print to PDF... Both nice options. I like the "new" modeling view, but I hate that the ALL TABLES view doesn't match the old modeling view I worked so hard to organize.

99fdd491 4a81-4111-add7-8e88ac138a27 on 05 Jul 2020 23:30:29

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

Strongly Agree. This is very much needed functionality to export Relationship model to Visio or similar tools.

dc2f6d8d e8c2-48e2-a5e5-827de18897d3 on 05 Jul 2020 23:22:02

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

strongly agree. We should have the ability to export relationships to Visio or similar tools.

1027f28d c482-47e9-a2dd-35d573ac5bdf on 05 Jul 2020 23:17:42

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

Yes! Absbsolutely behind this idea.

Import would be handy as well (cross compatability to Excel/Access etc would be a dream!)

ffbe43f0 9082-4d4e-a4c0-5803e7f90581 on 05 Jul 2020 23:15:52

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

'Essencial enhancements, we need both:
- a list including tables and field tables
- the schematic flow diagram showing the field relationship

This will help us in the design, troubleshooting and improving the BI visualization and analytics.