can't determine relationships between fields

[zebra]

Hi All,

I am having trouble in getting data into visuals with following model.

Here Table2 is a primary table where table 1 and table 3 contains its primary key as foreign key. If I add columns from table 1 and table2 to any visual, it work fine however as soon as i add any column from table 3. it says following error.

As suggested by others, I also tried cross filter diection from single to both, however it did not work. I am under the impression that relationships should work like they work in sql however it looks like that power bi work differently.  could anybody put some light why it is not working or any workaround?

[andhiii079845]

I think you have to show some data examples and your visual that you created. i would try before all bi directional combinations, only tab 1, only tab 2, all tab. 

[andhiii079845]

Do you try to cross filter both tables? Are both tables from the same source? Which connection mode do you use?

[zebra]

yes, i tried cross filter both tables. and yes both tables from the same source and I am using ODBC connection to get data from mongodb.

[andhiii079845]

do you use direct query or import mode?

[zebra]

import mode.