Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin 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.
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.
Solved! Go to 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.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
32 | |
20 | |
19 | |
14 | |
12 |
User | Count |
---|---|
27 | |
18 | |
16 | |
16 | |
14 |