Easily export relationships between tables into a Spreadsheet or table
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.
That would be really great.
Kel C commented
This is still immediately needed. Even just the ability to print this to a readable pdf would be good. I have dozens of tables (too many for a snipit tool) and am required to document the relationships that drive our reports.
The only other option is to recreate all the work I've already done in powerbi into Visio, which is a giant duplication of effort.
Please add an export feature asap
Yes, Please add this feature. Every user might need that at some point. Thanks
Colin Hodges commented
required for enterprise scale solutions. do it.
David Camacho commented
As a data modeler it is required to have the clear picture of these relationships. Other tools have the option to export the info also in XML formats
An export to Visio would be fantastic, even showing only those fields from the relationship view that are actually being used to make relationships.
Eric Jacobson commented
This is needed even more now, since we are using Power BI service Live connection. The modeling tab is not visible, so a user cannot even see the relationships between entities. Having a quick way to print/export this view and make available would help.
Jason Smith commented
Any update on this please as I can't believe I need to run a seperate data modelling tool just to print a model layout when we have all the information there.
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?
Please add this. We need it to be able to discuss future links to other sources and for documentation. We can't live without!!
Agreed. Our number of tables is getting large and this would be helpful for distributing to the development team.
Thomas C. commented
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.
when this is coming! BUMP!
Daniel Davis commented
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.
Strongly Agree. This is very much needed functionality to export Relationship model to Visio or similar tools.
strongly agree. We should have the ability to export relationships to Visio or similar tools.
Yes! Absbsolutely behind this idea.
Import would be handy as well (cross compatability to Excel/Access etc would be a dream!)
Leonardo Elmor commented
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.
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.
This would be very useful for everyone is this likely to happen?