Adding field as a column on a table visual using power bi desktop

[billf]

Used Dataverse to create custom tables and relationships.

Table A is connected to table B using a many to many relationship using joining table generated by dataverse.  Table B connected to Table C using a one to many relationship.

Using Power BI desktop, I can connect and display fields from table A and B on a table visual.  When I try to add a field from table C to the visual, I get the following error.

Can't determine relationships between the fields.

This doesn't make sense since I can clearly see the proper join between tables B and C on the schema diagram.  I also have this exact same setup on an environment using Azure SQL and have no problems connecting and pulling any field I want to build report.

I've tried everything from rebuilding the relationships to changing cross filter direction options to no avail.

Please help.

[billf · Accepted solution]

I was able to resolve this.  I had to break the relationship between table B and C in Power BI schema only.  Then joined the joining table between table A and Table B with Table C using a one to many relationship.  Works great now.