Matt Allington on 09 Feb 2018 03:55:03
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.
Administrator on 17 Jun 2021 00:14:42
Improvements have been made to the modeling and relationship creating experience.
- Comments (4)
RE: Improve Relationship Drag and Drop Experience
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'!
RE: Improve Relationship Drag and Drop Experience
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.
RE: Improve Relationship Drag and Drop Experience
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.
RE: Improve Relationship Drag and Drop Experience
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.