Forum Discussion

Anonymous

Not applicable

9 years ago

Solved

Create Relationship

I'm tring to create the relationship between two "description", i'm 100% sure the 'description' under "masterCategory-OfficeTools' is unique. plus why 'description' and 'Category' had Sum symbol a...

dkay84_PowerBI
9 years ago
In the query editor there is a remove duplicates function when you import your data from excel. Did you ever try using that?

Also in excel are you checking for dups on just the one column or the two that look highlighted?

Icon for Super User rank

Super User

9 years ago

As message says, seems like your both table have duplicate values, one has to be unique.

Basically you cannot have many to many relationship, check your related to table if that contains duplicate values.