Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
32 | |
26 | |
24 | |
19 | |
16 |
User | Count |
---|---|
49 | |
38 | |
24 | |
20 | |
20 |