Forum Discussion
RLS using EntraId groups on Warehouse
Hi Srisakthi , Shreya_Barhate ,
Sure I would like to help you help on this!
Here is a working example on how to implement RLS using Entra ID groups in Warehouse and SQL Endpoint-
Microsoft Fabric Row-Level Security (RLS) & Column-Level security(CLS) in Warehouse and SQL Endpoint
Hope this helps!
If the response has addressed your query, please accept it as a solution so that other members can easily find it.
Thank You!
hi v-sdhruv
Thanks for sharing the link! I went through the example, and it looks like it demonstrates Column-Level Security (CLS) using Active Directory (AD) groups, not Row-Level Security (RLS). I'm specifically looking for a sample script that applies RLS using AD groups (via Entra ID) on Microsoft Fabric Warehouse.
If you have any examples or resources that show how to implement RLS with AD groups, I’d really appreciate it!
Thanks & Regards,
Shreya
Hi Shreya_Barhate ,
I looked across some resources and found a working example for RLS using AD groups which might help you with your query.
https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/
Hope this helps!Hi v-sdhruv ,
Thanks for sharing the resource! This approach using AD groups for RLS looks great and should work well in Power BI.
However, for our current use case involving Fabric Warehouse, this method won’t be applicable.
Thanks and regards,
ShreyaHi Shreya_Barhate ,
I am sorry if that didnt help.
I would request you raise a Support ticket-
Link - How to create a Support Ticket
Hope this helps!