Complex data modelling breaking my table visual

[Anonymous]

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