Forum Discussion

Revati25's avatar
Revati25
Icon for Advocate I rankAdvocate I
1 year ago
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...
Need Help
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    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.

     

nilendraFabric's avatar
nilendraFabric
Icon for Super User rankSuper User
1 year ago

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.

 

Revati25's avatar
Revati25
Icon for Advocate I rankAdvocate I
1 year ago

Thank you for the solution.