topic Re: RLS using Windows Security Groups in DAX Commands and Tips

RLS using Windows Security Groups

DataEngineer314 — Mon, 21 Oct 2024 13:11:29 GMT

Hello all, I am trying to configure RLS for some reports using windows security groups. The structure I have is:

I need to use the security group to filter the franchisee ID in Dim Store: this is the best I can put the logic:

RLS[ObjectID] = USEROBJECTID() &&

TREATAS(VALUES(RLS[Franchisee_ID]), Dim_Stands[Franchisee_ID])

But of course this doesnt work. Can anyone provide me with some DAX or an example on how to do this from the RLS side?

lbendlin — Mon, 21 Oct 2024 15:01:37 GMT

This is standard static RLS. Create roles, one for each security group. Then in the service assign each group to their role.

xifeng_L — Mon, 21 Oct 2024 15:17:15 GMT

You can refer to below demo.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

Anonymous — Tue, 22 Oct 2024 08:19:17 GMT

Did xifeng_L reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.

Best regards,