Forum Discussion
Create Relationship
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?
Super UserAs 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.
parry2kYes, i know that. 1 table definitly have no duplicate, I've tried many ways, even delete the bottom rows to make sure no any blank values. but still give me the same message. i've done similar things, but don't have that problem before. any other possiblity might caursing that error? thanks.
- dkay84_PowerBI
Microsoft Employee
1. In the query editor, reference your fact table[column]
2. Convert to table
3. Trim and Clean this column
4. Remove dups
5. Close and Apply
6. Create relationship from your fact table to this dimension table and from this dimension table to your other table
See if this allows you to build the relationship
- parry2k
dkay84_PowerBI he already confirmed there are no duplicates
- dkay84_PowerBI
parry2k I've had situations in the past where unprintable characters in a record(s) were creating this problem of not being able to create a relationship
- parry2k
Did you looked at Cross Filter Direction on relationship window? Not sure if that has anything to do with this but check if it is single