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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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