Forum Discussion
Row level security on Composite Models
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
Hi Rajesh_Yarlagad ,
Thanks for reaching out to the Microsoft fabric community forum.
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.
6 Replies
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
Hi Rajesh_Yarlagad
Please relate to the linked video:
https://www.youtube.com/watch?v=IX6FgC3cRwIIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Rajesh_Yarlagad ,
Thanks for reaching out to the Microsoft fabric community forum.
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.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.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.
