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

David Heiss on 06 Jul 2020 00:11:49

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

That would be really great.

Phil Boguszewski's profile image Profile Picture

Kel C on 06 Jul 2020 00:08:04

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

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

Phil Boguszewski's profile image Profile Picture

Morteza Moarefian on 06 Jul 2020 00:07:48

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

Yes, Please add this feature. Every user might need that at some point. Thanks

Phil Boguszewski's profile image Profile Picture

Colin Hodges on 06 Jul 2020 00:06:03

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

required for enterprise scale solutions. do it.

Phil Boguszewski's profile image Profile Picture

David Camacho on 06 Jul 2020 00:03:14

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

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

Phil Boguszewski's profile image Profile Picture

Tim on 06 Jul 2020 00:00:35

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

An export to Visio would be fantastic, even showing only those fields from the relationship view that are actually being used to make relationships.

Phil Boguszewski's profile image Profile Picture

Eric Jacobson on 05 Jul 2020 23:53:10

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

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.

Phil Boguszewski's profile image Profile Picture

Jason Smith on 05 Jul 2020 23:49:56

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

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.

Phil Boguszewski's profile image Profile Picture

arne 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?

Phil Boguszewski's profile image Profile Picture

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