RLS partially working in Power BI Desktop but not in Power BI Service

[giramswa]

Hi All,

I have created a Role called 'Line_Manager' to show only the logged in users name in slicer ([EMPLOYEE_LOGIN_ID] = username()).

When I test it using 'View As', I can see only my name in slicer, which otherwise would show list of all employees.

Published this report.  

I then added some manager names, along with my name under the role in the Security menu on this report:

When I try to test this in Power BI service, the slicer does not show any records, while the same slicer in Power BI desktop show my name. How to fix this?

[v-xiaotang · Accepted solution]

Hi @giramswa 

Thanks for reaching out to us.

Try userprincipalname() instead, for the reason please check this blog: USERNAME() v/s USERPRINCIPALNAME() in RLS for Pow... - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.