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 (8)
RE: Delete/Deactivate all Current Relationships
You can bulk delete relationships via the Model view > Manage relationships dialog box. Ctrl or Shift works to allow multi-select and then Delete.
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.
RE: Delete/Deactivate all Current Relationships
Yes
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.
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.
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
RE: Delete/Deactivate all Current Relationships
I agree as well
RE: Delete/Deactivate all Current Relationships
I agree