Relationship problem

[Syndicate_Admin]

Good afternoon! I'm very new to Power BI.
I have a problem when I relate two tables to a table, for the same ID, it gives me error "you cannot determine the relationships", unless you relate the two child tables to each other by means of a many-to-many relationship and there it works, is it ok that you relate it like this?

[Anonymous · Accepted solution]

Hi @ihernandez ,

This closed-loop relationship is not allowed in Power BI, which will cause you problems with subsequent report creation, measure creation, etc., so please remove this many-to-many relationship:

Multiple active relationships create conflicts. Multiple relationships may lead to unclear dependencies between tables.
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Many-to-many relationship guidance - Power BI | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.