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.
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'!
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
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
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.