How to connect 2 tables to another table in Model tab.

[croberts21]

I have the free PBI Desktop v2.100.1182 (64 bit free version Dec 2021) on Windows 10.

We have 2 tables, call them CTime and NCTime, with key fields that both link to the same field in another table called CostCenter. But in the Model tab (where relationships between tables are defined) PBI will only let me link one table to CostCenter.

All our datasources are based on an ODBC SQL statement. For each datasoure/SQL statement I try to only get fields from one table, and then I link them via key fields in the PBI Models tab.

Is it possible to have PBI allow me to link CTime and NCTime to the CostCenter table? Or do I have to rewrite some of my SQL statements in my datasources to link to CostCenter?

Thank you!

[v-kkf-msft]

Hi @croberts21 ,

Did you establish a relationship between your table CTime and table NCTime? Because Power BI does not allow relationships like A -> B -> C -> A.

Best Regards,
Winniz

[HotChilli · Accepted solution]

Try doing it from 'Manage Relationships' on the ribbon.

You should get feedback messages if there are problems. 

[HotChilli]

I will need to see more detail.

Let's start with this "But in the Model tab (where relationships between tables are defined) PBI will only let me link one table to CostCenter." Is there a message?

[croberts21]

There is no error message, I try to drag one field in one table to connect it to the same key field in another table and PBI will not let me make the connection.