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
Fabric Community Sticker Challenge - Barcelona 2026
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Power BI Monthly Update - July 2026
Check out the July 2026 Power BI update to learn about new features.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
