Skip to main content

Power BI

New

Delete/Deactivate all Current Relationships

Vote (33) Share
Natalie's profile image

Natalie on 06 Jul 2018 23:28:18

I feel that having the ability to completely delete or deactivate all existing relationships would be a good usability feature especially when working with larger data sets.

While you are given the option at the start to choose to auto generate relationships, there doesn't seem to be a way to reverse that decision without manually deleting them, or re-importing the entire data set from the beginning.

Comments (7)
Natalie's profile image Profile Picture

17d41cab e939-45fe-973b-f00d061968af on 06 Jul 2020 00:09:58

RE: Delete/Deactivate all Current Relationships

Please look into this as a feature! Or have the auto-detect relationships turned off as a default and prompt the user if this is what they want with each new .pbix created.

Natalie's profile image Profile Picture

8b74108d 83e9-4f7e-866a-e9f522b209f2 on 06 Jul 2020 00:05:49

RE: Delete/Deactivate all Current Relationships

Yes

Natalie's profile image Profile Picture

1d69b887 2075-44bc-91eb-58d8d11b250d on 06 Jul 2020 00:04:38

RE: Delete/Deactivate all Current Relationships

I concur - I wanted to see what PowerBI does with relationships but it was very poor. Now I have to delete each one at a time and the tool is not exactly fast.

Natalie's profile image Profile Picture

65c88a40 2a5b-4b65-9906-a3d11145690d on 06 Jul 2020 00:03:18

RE: Delete/Deactivate all Current Relationships

Agreed, provided you could run the command just on one table in isolation or on all tables in one go.

And please please PowerBI stop asking me "Are you sure?" Yes I am. If I make a mistake, I can easily draw it in again.

Stop the #ClickTax.

Natalie's profile image Profile Picture

b08d4706 f279-4585-ab7e-6bdda664420a on 05 Jul 2020 23:54:22

RE: Delete/Deactivate all Current Relationships

Improve the control, the visibility and the speed we select few, view can add, delete, change connections and relationship is a major opportunity in BI desktop

Natalie's profile image Profile Picture

c33d81f5 311a-4594-81c6-1c28778a5b1a on 05 Jul 2020 23:45:29

RE: Delete/Deactivate all Current Relationships

I agree as well

Natalie's profile image Profile Picture

65b04b16 c7a3-4c10-9d9e-ce6481d4ed47 on 05 Jul 2020 23:41:41

RE: Delete/Deactivate all Current Relationships

I agree