So I am trying to implement RLS using the documentation in the link below
my 1st step was to create a bridge table as discuss in this youtube video (Guy in a Cube 1:54 seconds in)
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!!!
Solved! Go to 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
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
I think this is the step you missed in the service