cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Row level security in SharePoint not working

Hi folks
For a dashboard I have in desktop Power BI.

  •  I created a Role called "DRLS" which filters the data: [Submitter.email] = UserPrincipalName()
  • In desktop when I View as I correctly only see the rows I should.
  • I publish to Power BI Service and in that service I add people to role "DRLS".
  • I right click on DRLS and choose Test as role. Works great.
  • I embed the report in a SharePoint page as a PowerBI webpart.
  • People go to the SharePoint page but row level security does not work: they see all rows.

This is quite puzzling. Other posts here suggest I do the above steps so any thoughts on what step I'm missing? 

Regards

Duncan

1 ACCEPTED SOLUTION
Super User III
Super User III

Please be more specific.  Are these "People"  members of the workspace, and if yes, do they have Editor roles or higher?

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#using-rls-with-workspaces-in-power...

View solution in original post

2 REPLIES 2
Microsoft
Microsoft

Hi @DuncanW 

 

Has this problem been solved? If so, kindly Accept the appropriate reply as the solution or post your own solution to help close this topic. More people will benefit from it. Thanks a lot.

 

Otherwise, you may refer to this link How to Setup Row Level Security (RLS) in Microsoft Power BI (key2consulting.com) for a detailed guidance on two ways to setting RLS in Power BI. When using UserPrincipalName() in RLS rules, you will need to include all the users' UPN in a table in the data model in advance or it will not work on the Service.

 

Additionally, RLS does not work when users are members who have edit access or higher of the report workspace. 


Best Regards,
Community Support Team _ Jing Zhang

Super User III
Super User III

Please be more specific.  Are these "People"  members of the workspace, and if yes, do they have Editor roles or higher?

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#using-rls-with-workspaces-in-power...

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors