Cant determine relationship between two or more fields

[Dunner2020]

I got a data model which looks as follow:

I am trying to show columns from different tables in a table visual. Table visual works fine when I use column from contact and AssetContact_Address tables. However, it throw error 'cant determine relationship between two or more fields' when I tried to put a column from the ContactRelationship table. I checked and there is no missing value in any table. I also changed the cross filter option from Single to both but did not work. Any help would be really appreciated.

Sample here.

[HoangHugo]

can you share some images, or sample for your case?

[Dunner2020]

@HoangHugo , sample file is attached in the thread (question). I am also attaching the gif of the issue.

[HoangHugo]

Hi,

I try your file, it is not working, but when I reorder the columns in table, it displayed. I also change your ID to type text. I think maybe this is error from app.

[Dunner2020]

@HoangHugo , can I have your sample file please?

[HoangHugo]

Link please check

[Dunner2020]

@HoangHugo thanks for the file. It's so wired that it worked fine on your side but not on mine. I also changed contactId type to text but did not make any difference

[HoangHugo]

Hi

I think AssetContact_Address and ContactRelationship should be ralted to same one column of Contact, to display right relationship between tables.

[Dunner2020]

@HoangHugo , they are related to the same one column of Contact table (i.e. ContactId)