does not let me join although one of the column has unique values

[fiveone]

I need to relate to tables, one is a fact tables with rates of ressources and another one is a dimension table with details regarding each ressource.

I made sure there is no null nor duplicates in the dimension table.

let
    source = #"Staff list",
    #"Filtered Rows1" = Table.SelectRows(source, each [Ressource] <> null and [Ressource] <> ""),
    #"Removed Duplicates" = Table.Distinct(#"Filtered Rows1", {"Ressource"})
in
    #"Removed Duplicates"

but PBI will still not let me join the 2 tables - it says that one of the columns must have unique values.

Any idea why it would not let join on the ressource column

[fiveone]

I inverstigated it further and it turns out there are indeed 2 records of one of the resource after the RemoveDuplicates step.

How is that even possible?

[fiveone · Accepted solution]

OK, problem solved.

There was a space at the end of one the names. I suspected that but it was not apparent in powerquery. Anyway this should not be considered as duplicates anyway, unless there is some automatic somewhere in the process, but where...