Row level security on Composite Models

[Rajesh_Yarlagad]

Hi All

I have a dataset A which has RLS configured on it. For simplicity, let us say I have security table(S1) and  one fact table (F1). I have configured RLS and defined role based on user principal name from S1 table and assigned members to this role in service. 

Now I created a dataset B by connecting to dataset A and imported another fact table (F2). Now thishas become a composite model(Direct query with Data set A and Import with F2). Now If i join security Table(S1)  with fact table(F2), will RLS be in place since role based on user principal name from S1 is already created in dataset A ? 

Thanks, 

Rajesh Kumar Yarlagadda

[v-lgarikapat · Accepted solution]

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.

[v-lgarikapat]

Hi @Rajesh_Yarlagad ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

Best Regards,
Lakshmi.

[v-lgarikapat]

Hi @Rajesh_Yarlagad ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

Best Regards,
Lakshmi.

[v-lgarikapat]

Hi @Rajesh_Yarlagad ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

Best Regards,
Lakshmi.

[Ritaf1983]

Hi @Rajesh_Yarlagad 
Please relate to the linked video:
https://www.youtube.com/watch?v=IX6FgC3cRwI

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[FBergamaschi]

The answer is yes if there is a one to many monidirectional relationship between S1 and F2

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI