Implementing RLS

[Emmy66]

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.

[vgangabharani]

In this article I have explained end to end of RLS https://grannyofpowerbi.blogspot.com/2021/06/row-level-security-rls.html

[v-janeyg-msft · Accepted solution]

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.

[Emmy66]

@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.

[fhill]

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.

https://www.youtube.com/watch?v=MxU_FYSSnYU

[fhill]

Check out this one also!

https://www.youtube.com/watch?v=9wN33rTaiB4

[Emmy66]

@fhill , thanks for your prompt response and the links you pointed me to. Very much appreciated. I've seen these videos prior to now but unfortunately, it didn't address my problem.