Forum Discussion
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...
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 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.
Even i have seen query editor works fine in deleting any dublicates.