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?
dkay84_PowerBI he already confirmed there are no duplicates
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
dkay84_PowerBI parry2k Baskar thanks, i think i've found the problem, it's the duplicates. i've created a chart below in power bi to find the duplicates for me. Yes, there are 1 value in twice. but still excel still tell me there is NO duplicates. Dam.
thanks all.
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?
wow, good to know it is resolved.
Cheers,
P
Even i have seen query editor works fine in deleting any dublicates.
That make sense, thanks for sharing your experience. I hope it resolve the issue for Anonymous
