Forum Discussion
Letting users build reports with Row Level Security
My team wants to give non-technical users the ability to create their own reports. We prepared the data model and created an empty report in powerbi service which they can edit and select any available fields and apply filters. They then save the edited copy to their own workspace.
The issue is we need to apply row-level security so that they can only see data that belongs to their division. Since we gave them contributor access to edit the reports, the row-level security is not applying. Any alternatives we can try to fulfill our requirements?
No, that's enough. From the Dataset Hub, users should see the Create Reports option
8 Replies
Syndicate_AdminAdministrator
Hello!
no, RLS only works with the viewer role. What you should do is assign them the role of viewer, and give them permission to compile content with the data. The help specifies in detail https://docs.microsoft.com/es-es/power-bi/admin/service-admin-rls "RLS roles apply to members who are assigned the Viewer role in the workspace. Even if viewers have build permissions for the dataset, RLS is still applied"
- Syndicate_Admin
Therefore, as I indicate, in addition to the role, you must give it permissions to "Compile content with the data", which is a permission specifically designed for what you need