RLS Configuration Issue

[Bbrown44]

So I am trying to implement RLS using the documentation in the link below

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

my 1st step was to create a bridge table as discuss in this youtube video (Guy in a Cube 1:54 seconds in)

https://youtu.be/9wN33rTaiB4

Here is the structure of my bridge table

my second step was to set Row Security on the bridge table see pic below

3rd step was to set manage roles and set the Principal email as "userprincipalname()" see below

3rd step was to test manage roles in view see below:

When i completed that step the view worked as I can only see the school related to Charlela on the bridge table

So I publish up to my Power BI Pro service and update the app for distribution see steps below

checked the app properties

made it accessable to my whole organization since the RLS will provide access via userprincipalname()

My final test was to see if Charlela could view her data via the app.

When she accessed the app she received this screenshot

I have no idea how to troubleshoot this now... PLEASE HELP!!!

~Bryon

[blopez11]

In the service, you need to assign users to the role you created

In the service, navigate to the dataset, then select the security option

You should see the role you created

Add users to the role

Good luck,

[blopez11]

I think this is the step you missed in the service

https://docs.microsoft.com/en-us/power-bi/service-admin-rls#manage-security-on-your-model

[Bbrown44]

RLS is no longer a function in Power BI Service so the documentation is out of date. see snapshot in thread

[blopez11 · Accepted solution]

It is true that RLS is now defined in the Desktop, but once defined in the Desktop and published to the service, you still have to assign users to the roles you created in the desktop

To get the the security option, navigate to your workspace, then datasets, select "...", the select Security

You should now see the role(s) you created, and from there you assign the users

[Bbrown44]

Thanks so much that worked!  Right now I am only setting security features for 12 users.  How would you set up a group of 1600 users?

[Bbrown44]

[OliveiraThiago]

@Bbrown44 I'm sorry, but I can't see it.

[Bbrown44]

RLS is no longer a function in Power BI Service so the documentation is out of date.

[OliveiraThiago]

Ok, I just tried and it worked. I am sorry, but I don't what is happening to your dataset. 

Cheers

[Bbrown44]

I don't see this fuction in Power BI Desktop for secruity... Also I am using 22 different tables in my model which one would I set security on?

[OliveiraThiago]

Hello @Bbrown44,

First question, is your RLS right? I mean, the role is working as it should? 

Second, the step @blopez11 mentioned is on Power BI service.

Cheers