Forum Discussion

garimajain85's avatar
garimajain85
Frequent Visitor
2 years ago
Solved

Dynamic Row Level Security

Has anyone utilized Row-Level Security (RLS) in their Power BI reports. Specifically, has anyone configured it such that individuals can access and view their own data, while preventing them from see...
Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    Hi garimajain85 ,

     

    Be aware that RLS only works for users with viewer permissions in the workspace, all other roles (admin, member or contributor) since can edit the reports don't have RLS applied because it won't make sense in terms of role.

     

    That is why you can't see the role working for you specifically.

Rajesh_Yarlagad's avatar
Rajesh_Yarlagad
Icon for Helper I rankHelper I
1 year ago

For testing, i have created user table(Store ID and Email adress) with some random email address. For default, I have given same email address in all rows for all store ID's  I have created a new role 'Access Control' where email id = userprincipalname().But when I try to view as 'Access Control'. Everything gets blanked out in table just showing the totals. When i view as other user (example : my email ID), it displays everything. It looks strange. Is there any fix for it ?