How can we improve Power BI?

Improve Relationship Drag and Drop Experience

In Power Pivot for Excel, when you drag and drop columns to create relationships, there experience is:
1. Click and drag source column
2. Hover over destination table
3. The receiving column on the destination table is highlighted to indicate which column will receive the join.

In Power BI Desktop, item 3 above is missing. It makes it ambiguous how the join will be made (and a poor user experience). Please add a visual confirmation to the user which column will receive the join during drag and drop.

439 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Matt Allington shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

4 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    Let's all agree -- 'data ambiguity' AND 'relationship ambiguity' have no place in PBI -- this 'relationship ambiguity' has got to go, and we'll all work on the 'data ambiguity'!

  • TEEGEE commented  ·   ·  Flag as inappropriate

    Also:
    When hovering over a relationship line, also highlight both the tables, as well as the joined column in each table (scrolling/zooming the window where necessary)
    When hoving over a table, highlight ALL its relationship lines AND the joined tables AND the joined columns in the respective tables.

    When taking over someone else's complex model, this would be a life saver.

  • Matt Allington commented  ·   ·  Flag as inappropriate

    Also, if you click or hover on the relationship, please make the tables scroll so I can see where the join is. This is the only reason to hover/click - to see this info. Double click of course to edit.

  • Vatsal Makadia commented  ·   ·  Flag as inappropriate

    When you drag and drop a relationship in Power BI, it is not clear where the join will be made so it needs to be improved. Perhaps, it can come up as zoomed text for 'field' to allow join to be made easier.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.