There are no duplicate values. But it appears that it is duplicated. What should be done?

Hi baasansurenfina, Hope you are doing good!

Please open power query editor and choose the mentioned column, click on remove duplicate and then select 'close and apply' after it retry creating the relationship.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!