RLS using Windows Security Groups

[DataEngineer314]

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?

[Anonymous]

Hi @DataEngineer314 ,

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,

[xifeng_L · Accepted solution]

@DataEngineer314 

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~

[lbendlin]

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