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.

292 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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.