Why related() function can not be used under DirectQuery

[babyjb1979]

The relation is as following: 

The AssetMaster table is pulled as a driectquery model. The other two equipment tables are connected with AssetMaster by "Internal Rate Group ", one to many. I want to toggle a column from Equipment Type table to AssetMaster table by using related function, but there is an error.

What can I do in this case?

Thank you in advance!

Branko

[amitchandak]

@babyjb1979 , Related can be used in direct query but only from to get data from 1 side to many side

refer - https://youtu.be/aA4ROG9dg8A