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

Power BI User 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.

Phil Boguszewski's profile image Profile Picture

Thomas C. 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.

Phil Boguszewski's profile image Profile Picture

Power BI User on 05 Jul 2020 23:42:06

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

when this is coming! BUMP!

Phil Boguszewski's profile image Profile Picture

Daniel Davis 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.

Phil Boguszewski's profile image Profile Picture

Power BI User 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.

Phil Boguszewski's profile image Profile Picture

Rani Barbir 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.

Phil Boguszewski's profile image Profile Picture

Elizabeth 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!)

Phil Boguszewski's profile image Profile Picture

Leonardo Elmor 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.

Phil Boguszewski's profile image Profile Picture

Jim Roake on 05 Jul 2020 23:00:31

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

The ability to print a relationship map is important especially in providing documentation to support the model. Some people work better with a visual hard copy to see where the solution / problem is occuring.

Phil Boguszewski's profile image Profile Picture

Power BI User on 05 Jul 2020 22:59:56

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

This would be very useful for everyone is this likely to happen?