Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
36 | |
30 | |
18 | |
13 | |
8 |
User | Count |
---|---|
50 | |
38 | |
31 | |
15 | |
13 |