relationships-one-to-one

[rmh]

Hi, I am refering to this article regarding one-to-one relationship in powerBI

https://docs.microsoft.com/en-us/power-bi/guidance/relationships-one-to-one

I get the following message when I try to link 2 table via table1-customerNumer (primarykey) and table2-customerNumber(foreign-key). I have tried via sql without any problem. Is it possible to get a more detailed error message to see what the problem is?

[v-chuncz-msft]

@rmh 

You may check if there is any duplicate value in table2.

[rmh]

There is no duplicate in any of the 2 tables. I thought it might be because of the Hierarchy, but it was not the reason. Very weird.