Forum Discussion
Solved
Toggle Row Level Securiy
Dear all, I have an application with the following data model : I have 4 RLS Tables : one for the hierarchy, one for the location, one for the country and one for the headcount. Basicall...
VAR _Selected_Role = VALUES(Param_Security_Role[Role]) -- User role selection
RETURN
_Selected_Role = "Hierarchy" && 'DIM_USER_RLS_HIERARCHY'[USER_EMAIL] = USERPRINCIPALNAME()
VAR _Selected_Role = VALUES(Param_Security_Role[Role]) -- User role selection
RETURN
_Selected_Role = "Hierarchy" && 'DIM_USER_RLS_HIERARCHY'[USER_EMAIL] = USERPRINCIPALNAME()
Hi
thanks for the reply.
For my test i tested with 2 roles with the "View as" (Role Hierarchy and Role Location)
When i select Role = Location OR Role = Hierarchy in my slicer, the Dim_Users is not filtered and then i see all the users. I need to force one specifc RLS Pattern with the Slicer Role. How can i achieve this ?
Thanks a lot
Frédéric