Relationships in Power BI

[Analitika]

Hi,

I would like ask why I can't connect tables one-to-one relationship? I am getting message: 

[Greg_Deckler]

@Analitika Somewhere you have a duplicate value in those columns or you have unmatched rows. The first issue might be caused because of the case insensitivity of DAX, something like AQ701 is the same as aQ701 is the same as aq701 is the same as Aq701, at least as far as Power BI is concerned. But, it really looks like the latter where you have a bunch of rows in your 2nd table that don't match anything in your first table.

[Analitika]

I tried to make table to be distinct but still seems it has  duplicates. Seems it is a reason that I can't make one-to-one relationship.

[Digger]

@Analitika remove blanks