Forum Discussion
RLS multiple roles for two reports using same dataset
Hi I have a problem with using different roles in each report using the same dataset. I tried searching but I found all articles confusing. Here is an example: In the first report, users should be able to see sales only of their region but allow them to see all "companies" in that region. In the second report, the users should be restricted to see only the companies assigned to them but all regions for that company. So generally, apply only RLS role 1 for Report A and RLS role 2 for report B. Now I have two datasets but it would be much better to have just one. I tried creating two roles but all rows were shown in each report. Any advice would be much appreciated.
Thanks,
Filip
2 Replies
Hi f1254lipm ,
RLS allows you to restrict data access for different users based on their roles and filters. You can create roles and filters in Power BI Desktop or in the Power BI Service, and assign users to those roles in Power BI Service. And RLS only restricts data access for users with Viewer permissions. It doesn't apply to Admins, Members, or Contributors.
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
You can refer the following links to configure RLS for your reports:
Using Dynamic Row-Level Security with Organizational Hierarchies - 3Cloud (3cloudsolutions.com)
Dynamic Row Level Security with Power BI Made Simple - RADACAD
Dynamic Row Level Security with Profiles and Users in Power BI : Many-to-Many Relationship - RADACAD
If RLS is not working as expected, please check if you have the similar situations as below:
- The users who consume the data have admin permissions on the dataset or the workspace where the dataset resides(above viewer role)
- The RLS filters are not defined or applied correctly in the dataset
- The users who consume the data have persistent filters enabled on the report or dashboard that uses the dataset
- Considerations and limitations
Best Regards
any answer to this problem so far?
i have a similar issue. 1 dataset, 2 reports. one user should see report A with RLS, report B without.
