Forum Discussion
Implementing RLS
Hi,
I would appreciate any assistance on this please. I’m trying to implement RLS on the attached model. My expected output should be such that a user in powerbi_users table can only have access to reports in the areas allocated to the individual. E.g. user (16) should have access to all the reports in all offices, all departments and all roles whilst id (11) will only have access to all offices but not departments or roles. Below is an extract of the powerbi_users table.
id | user_uid | all_offices | all_departments | all_roles |
1 | 5af43ff508da2 | 0 | 1 | 1 |
6 | 5af4401675a94 | 1 | 1 | 0 |
11 | 5afec3f7334ba | 1 | 0 | 0 |
16 | 5bbc890345e7b | 1 | 1 | 1 |
21 | 5bbc89037c3cc | 1 | 0 | 0 |
I’ve attached the pbix file. The end goal is to embed the report so that different users from different companies can access the report.
Hi, Emmy66
According to your description, You need to set up RLS several times in different situations.
Like this:
Then set the user that meets each situation in the pbi service.
Follow the tutorial step by step:Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
If you don't follow GuyInACube , I highly recommend doing so. Here's a great quick simple video to go over how to enable RLS.
Hi, Emmy66
According to your description, You need to set up RLS several times in different situations.
Like this:
Then set the user that meets each situation in the pbi service.
Follow the tutorial step by step:Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-janeyg-msft , my appologies for late response. Thanks for your proposed solution. It didn't work in my case, so I had to result to creating a SQL statement which gets updated once any user is added to view the dashboard thru our application as pbi is embedded. Thanks again for taking time to respond to my request.
In this article I have explained end to end of RLS https://grannyofpowerbi.blogspot.com/2021/06/row-level-security-rls.html
