Forum Discussion
Can't Create Relationships - missing intermediate data to connect the two columns
I am attempting to create a relationship between the MainData Table and GroupDetail Table via the GroupNumber & Group Name. However I am getting the following issue: Why? Thanks!
PowerBIDesktop shows this message when it detects a Many-Many relationship (which are not supported). Basically at least one of the columns must have unique non null values.
Please doublecheck that the GroupDetails[GroupName] column doesn't have duplicates or nulls. (BTW comparison is case insensitive so "GROUP 1" and "group 1" are considered a dupe). If you find a dupe/null you can filter it out in the "Edit Query" view and retry to create the relationship.