Skip to main content

Power BI

Needs Votes

Edit Relationships in Power BI Online (Website)

Vote (367) Share
's profile image

on 15 Oct 2015 05:49:19

It would great if we can modify/create relationships in Power BI Website. For instance, when we connect directly to an Azure Data Warehouse, there is no relationships between the tables. So having the ability to edit relationships on Power BI Online would be really good.

Comments (34)
's profile image Profile Picture

27891712 a300-423b-b838-528b9733245d on 06 Jul 2020 00:17:28

RE: Edit Relationships in Power BI Online (Website)

This is ridiculously primitive! Hope it is fixed asap - creating flattened monsters tables as a workaround can only go so far!

's profile image Profile Picture

51f24093 4246-4389-81bb-91daaf0c0eae on 06 Jul 2020 00:04:46

RE: Edit Relationships in Power BI Online (Website)

There is no future for PBI if this is not sorted. Its a standard feature!!!!

's profile image Profile Picture

b2cb0182 d693-4908-b796-79cdb12f8bbf on 06 Jul 2020 00:04:02

RE: Edit Relationships in Power BI Online (Website)

Concur with the below. We have Quickbooks data through PowerBI's app and want to combine with other data e.g. an account map so I create custom reports showing different levels of detail. Didn't think this would not be possible. PowerBI not much use without this.

's profile image Profile Picture

1da36639 9865-40a3-a754-31f75d0320ef on 05 Jul 2020 23:57:08

RE: Edit Relationships in Power BI Online (Website)

The use case that I'd like to see a reality is something like this:

1. IT/Analysts etc make datasets/apps in Power BI using corporate data in the desktop
2. Business users capture and compile data in their business units (surveys, responses, ad hoc analyses, proposals etc) that is ad hoc, short term or otherwise not part of a line-of-business system lending itself to inclusion in the datasets
3. The data prepared by the business units can be related to existing datasets by common identifiers like customer, supplier, project, dates etc by business users in the browser

It is this last point that is compelling for me. Many corporate environments won't tolerate the idea of Power BI desktop rolled out and updated for all users but our Pro licensed users (everyone these days!) would have an excellent opportunity to self-serve with anywhere/anytime access if this capability were enabled online.

's profile image Profile Picture

c7d0e506 ffee-4831-b4ff-b6024e63c1ae on 05 Jul 2020 23:42:29

RE: Edit Relationships in Power BI Online (Website)

Linking table columns together is definitely a much needed function. Disparate datasets while working on projects exclusively utilising cloud services provided by Microsoft I believe to be below par for the current market. I for one amongst all the others who have previously commented and voted would welcome this with open arms. PowerBI desktop is NOT the future. Surely.

's profile image Profile Picture

439766ef b10b-421c-842b-948d0cbed5d6 on 05 Jul 2020 23:42:23

RE: Edit Relationships in Power BI Online (Website)

Que raro que no exista aun esta funcionalidad. Debe ser inminente

's profile image Profile Picture

9d2b699e 49d9-4f88-a4f1-0f1a941e8993 on 05 Jul 2020 23:39:01

RE: Edit Relationships in Power BI Online (Website)

I strongly agree.

's profile image Profile Picture

7c33b656 4479-46c0-ae0c-bbb5138d0346 on 05 Jul 2020 23:29:20

RE: Edit Relationships in Power BI Online (Website)

A much-needed feature

's profile image Profile Picture

7440bcec aa96-4fd0-8192-021f53b421a2 on 05 Jul 2020 23:27:59

RE: Edit Relationships in Power BI Online (Website)

Coming up on the 3-year anniversary for this basic request. Repeatedly noted as a "must have". Still hoping...

's profile image Profile Picture

b25811a2 8ff7-48ab-a609-d01f9591c195 on 05 Jul 2020 23:18:39

RE: Edit Relationships in Power BI Online (Website)

Having datasets that can be shared linked via the Desktop app is great, but when you cannot build relationships it falls down.

I would rather build all my datasets and relationships online and share to users via the PowerBI service to the Desktop application