Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
billf
New Member

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

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.

1 ACCEPTED SOLUTION
billf
New Member

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.

View solution in original post

1 REPLY 1
billf
New Member

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.