Forum Discussion
RLS using Windows Security Groups
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?
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~
3 Replies
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~
This is standard static RLS. Create roles, one for each security group. Then in the service assign each group to their role.
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,
