Forum Discussion

Revati25's avatar
Revati25
Advocate 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.

     

v-prasare's avatar
v-prasare
Community Support
1 year ago

Hi Revati25,As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query