Forum Discussion
Row level security in Power BI service
Hi,
I am trying to implement a RLS on the Power BI service.
I have a table in the database with a mapping of User Id and Department. And I am filtering the departments on the basis of User Id.
I used the userprincipalname() function while creating roles and fetched the user id and matched with the database user id.
Now when I create a report in Desktop, the departments shown are only the ones applicable to any particular id.
But the same doesn't happen when I see that report after being published in the Power BI service.
Any idea how do I implement this security on the service.
Thanks in advance.
hi Anonymous - Just to confirm, you have created role in Power BI desktop correct? Have you assigned folks to the specific roles after publishing the report to service?
Please follow the steps as per the Microsoft documentation to create and assign members to specific roles for RLS to work as expected.
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
Also RLS is only applied to folks with "Viewer" access to reports / workspace; RLS will not apply to users with other levels of access.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
1 Reply
hi Anonymous - Just to confirm, you have created role in Power BI desktop correct? Have you assigned folks to the specific roles after publishing the report to service?
Please follow the steps as per the Microsoft documentation to create and assign members to specific roles for RLS to work as expected.
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
Also RLS is only applied to folks with "Viewer" access to reports / workspace; RLS will not apply to users with other levels of access.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!