Hi,
To give some context, I have a database with all the relationships established in it. When i exported all the tables into power BI data model is automatically created for simplicity I'm including only 4 tables out of all which i needed.
As you can see relationships are established between the top 3 tables(datatemplate,groupofproperties and properties) using bottom 2 tables(assignment tables).
Actual problem I'm facing when I create a table in the power BI with few columns from Datatemplate, Groupofproperties and properties table, If I use any two (Datatemplate and groupofproperties) or (GroupofProperties and properties) I could able to create the table but when I add the 3rd table I'm getting the following error.
I suspect it to be some thing to do with the datamodel but could not figure out why I'm encountering this behaviour where as I can fire some query on sql server and get the data in desired format. Can power BI not handles composite relationships (A->B->C->D) like having two to three linking tables between?
Regards
Kiran
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
