RLS pass from Parent semantic model to child semantic model

[Melikag]

I have a RLS semantic model with 4 restricted tables and applied RLS published to a workspace. I need a new semantic model with 2 tables coming from the RLS semantic model and the rest coming from a mirrored database all tables in directquery mode. When trying testing in desktop, manage roles and view as roles are grayed out. I tested the RLS with a user and everything works fine, it seems like RLS is not passes from Parent semantic modle to child. With the child semantic model a test users gets this error:

Error fetching data for this visual

A connection could not be made to the data source with the Name of '{"protocol":"analysis-services","address":{"server":"powerbi://api.powerbi.com/v1.0/myorg/RLS%20Restricted%20Tables","database":"RLS Semantic Model"},"authentication":null,"query":null}'.

[v-hashadapu · Accepted solution]

Hi @Melikag , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answers that helped 'Accept as Solution', so others with similar queries can find them easily. If not, please share the details.
Thank you.

[GilbertQ]

Hi @Melikag 

Yes, that is correct because rail level security cannot be passed between two different semantic models. You will have to build the same role of security in the 2nd semantic model.