cancel
Showing results for 
Search instead for 
Did you mean: 

Role Level Security not Functioning in Service

Hello,

 

I am working on Role Level security using the Dynamic function "Userprincipalname()" based on a column with manager's emails in all associated roows of data. It wirks great in Power Bi Desktop, but when published in the Cloud Service it does not operate as it should.  When I test as Role and enter a user's information when assigned as a manager in the in the role options it does not filter the data down, or it give me no data.

 

If there are any ideas please assist.

 

Thank you,

Nick Patel

 

Power Bi RLS Issues 2019 10 22 (1).JPGRole Test no DataPower Bi RLS Issues 2019 10 22 (2).JPGRole TEst with All dataPower Bi RLS Issues 2019 10 22 (3).JPGSecurity SetupPower Bi RLS Issues 2019 10 22 (4).JPGDesktop Dynamic ExpressionPower Bi RLS Issues 2019 10 22 (5).JPGDesktop Data filtered by rolePower Bi RLS Issues 2019 10 22 (6).JPGDesktop Data filtered by rolePower Bi RLS Issues 2019 10 22 (7).JPGDesktop columns for expression

Status: Accepted
Comments
Community Support Team

@NickPatelMRCG ,

 

Currently there's a known issue of RLS, please refer to doc below:

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

 

The workaround is to republish the report to power bi service again.

 

Regards,

Jimmy Tao

Community Support Team
Status changed to: Accepted