Forum Discussion

Rajesh_Yarlagad's avatar
Rajesh_Yarlagad
Helper I
1 year ago
Solved

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 principa...
Data Protection
Need Help
v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

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's avatar
v-lgarikapat
Community Support
1 year ago

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's avatar
    v-lgarikapat
    Community Support
    1 year ago

    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's avatar
      v-lgarikapat
      Community Support
      11 months ago

      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.