after deleting duplicates still duplicates

[Satch]

In the Query editor I removed double values by Table.distinct(Source, {"Artikelnr"})

But there still are duplicates.

Cannot create a relationship because of duplicate key value.

When I look in the records, there is a value which exist 3 times.

Anyone knows why?

[Anonymous]

First thing i'd try is to run a "Trim" operation before removing duplicates.  Its possible you have "Artikelnr" and "Artikelnr " which Power BI see's as different.

Next thing to make sure, don't have any blank values in your unique column.  Filter those out too.

[Satch · Accepted solution]

It's about the Uppercase/lowercase

First had to convert the values to lowercase, and then it filters distinct the right way