Skip to main content
Microsoft Idea

Power BI

Needs Votes

Include data source table relationships when creating dataflow

Vote (33) Share
Fernando Lammoglia's profile image

Fernando Lammoglia on 23 Feb 2019 04:45:44

When creating a new dataflow, offer the option to include table relationships into the dataflow. Otherwise, each time I create a new report connecting to the dataflow I have to create table relationships

Comments (5)
Fernando Lammoglia's profile image Profile Picture

Joy Wu on 12 Apr 2022 04:38:23

RE: Include data source table relationships when creating dataflow

I am working on a wide range of data sources and designing reports that serve different purposes. Most of the report are using the shared data sources so it would be great to include the relationships into the dataflow so that I don't need to create the relationshop every single time for new reports.

Fernando Lammoglia's profile image Profile Picture

Gord Bogart on 15 Nov 2021 18:10:04

RE: Include data source table relationships when creating dataflow

The purpose of dataflows (standardized, reusable data for non-technical people) falls apart if you are expecting non-technical people to know how to link set of tables. Dataflows are currently only half a solution.

Fernando Lammoglia's profile image Profile Picture

Tondar ALIZADEH on 09 Nov 2021 03:51:15

RE: Include data source table relationships when creating dataflow

Completely agree with the comments above. When tables are being added from existing relational databases, it would be great if the relationships can also be imported as an optional component.

Fernando Lammoglia's profile image Profile Picture

David Edwards on 02 Oct 2021 00:08:58

RE: Include data source table relationships when creating dataflow

I believe this feature to be highly beneficial. I have built data flows with groups of tables specific to departments. I love the idea and function of data flows, but expecting non-data analytic employees to understand table relationships and set them up every time would be an issue and negate the idea of sharing the data flow from and efficiency standpoint. Obviously the relationships would be tied to the tables within the individual data flow, but the ability to still add other data flows without the relationships from the other disappearing would be helpful too. I only say that because I have broken up separate flows by departments as well as data sources(in certain situations), but the necessity may be to pull from multiple flows and also in the case of date table dataflows.

Fernando Lammoglia's profile image Profile Picture

Fernando Lammoglia on 05 Jul 2020 23:41:50

RE: Include data source table relationships when creating dataflow

When creating a new dataflow, offer the option to include table relationships into the dataflow. Otherwise, each time I create a new report connecting to the dataflow I have to create table relationships