Forum Discussion
Solved
RLS on region level
I am trying to apply RLS such that, I have an excel file with user email and region and main table containing data with region I want to create a role such that, if one user belonging to specific us...
Hello Revati25
Try replacing = with IN
And Confirm that the email addresses stored in your mapping file exactly match those returned by USERPRINCIPALNAME()
Ensure that the mapping table and your MainTable have the proper relationship.
MainTable[Region] IN
CALCULATETABLE(
VALUES('Access File for Region'[Region]),
'Access File for Region'[Email] = USERPRINCIPALNAME()
)Test the role as a viewer to see the expected results.
You have to remember if you are testing on the service, if you are a workspace admin, even if you are in a role it will not apply.
You can locally in power bi desktop by selecting view as from modelling tab of the ribbon. Or you can connect to the model with Dax studio and impersonate another user in the role