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)

342ebc94 c6c9-ea11-a813-000d3a579c38 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).

52a5d367 dbc6-ea11-a812-000d3a4e3654 on 15 Jul 2020 20:45:17

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

Feature to export it to Visio?

c7bad8e7 c074-463d-96d1-6947cf11ba2d on 06 Jul 2020 00:11:49

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

That would be really great.

7f1d467b dee3-4cd6-8099-ed91d35f4390 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

9d1e24d6 5e16-42fe-85ee-cb1535226d5c 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

851b365f 1756-48ec-9461-bd7e880420a3 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.

0401bfd2 ebc3-4adf-b3ca-e53564e26eaf 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

594f27dc 1a9c-42b0-a586-3a1626d16d35 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.

3bf28a60 c57a-482b-bd7b-7cfa8efcced4 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.

474a71cf d6bb-4b54-a6b7-fd376f73870d 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.