Row level security on Composite Models

Hi Rajesh_Yarlagad ,

Thanks for reaching out to the Microsoft fabric community forum.

Ritaf1983 ,

FBergamaschi 

Thanks for your prompt response

 In Additition to FBergamaschi , Ritaf1983  

1)Duplicate RLS Logic in Dataset B

• Recreate the RLS roles in Dataset B using the same logic from S1.
• You’ll need to ensure S1 is available in Dataset B (either via DirectQuery or import) and define roles that filter F2 accordingly.

 2) Push F2 into Dataset A

• If feasible, move F2 into Dataset A so that all tables are governed by the same RLS configuration.

This simplifies governance and avoids composite model complexity

Solved: RLS in composite mode - Microsoft Fabric Community

Solved: Row level security with Power BI Shared Dataset - Microsoft Fabric Community

Solved: How to properly implement RLS with shared datasets... - Microsoft Fabric Community

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
Lakshmi.