Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

RLS

Hi, I have a Power BI report with P&L data at the customer, country and region level. I received a request to - restrict sales managers' access based on customer, country and region. For example; w...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , What I usually do is I get email and list off access of county in one table and email and list of customer and configure RLS on both using userprincipalname

     

    Business leader should have access to all locations/country 

  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, Anonymous 

    Has the user been assigned a role other than "Viewer" in the workspace? RLS cannot take effect on roles (admins, members, contributors) that have access to dataset.

    Best Regards,
    Community Support Team _ Eason

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi, Anonymous 

Has the user been assigned a role other than "Viewer" in the workspace? RLS cannot take effect on roles (admins, members, contributors) that have access to dataset.

Best Regards,
Community Support Team _ Eason

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

v-easonf-msft The users were assigned to the 'member' role. I updated it to 'viewer' and RLS is working. Thanks for your input!