Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.