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 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.
Microsoft EmployeeIn 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
Sometimes I run into trouble when importing excel data (non-printable characters) for whatever reason. I always do a trim and clean to remove any inadvertant characters or whitespace that may be in the cell's value in order for PBI to read it correctly.
- parry2k
Super User
wow, good to know it is resolved.
Cheers,
P
dkay84_PowerBI no. i alway remove duplicates from excel and it's normally work. but will try in the future. thanks.
dkay84_PowerBIhow you do the clean in power bi? could you please describe a bit detail? many thanks.
- dkay84_PowerBIIn the query editor there is a built in function (under Transform tab I believe). Not sure if there is a DAX equivalent although there is a CLEAN function in excel.
