Forum Discussion
RLS doesn´t work in an specific workspace
- 5 years ago
I had to create other workspace and migrate the reports, I think my problem was that the workspace was created since teams app and automatically take the users from teams app and Power BI assign the member role, I tried change the role to viewer and even remove the role by group and only leave individual roles as viewer, but doesn´t work.
I hope this be helpful to consider when work with a workspace created from teams app.
HiRicLup if you are using USERNAME() in power bi desktop or User principal, I know PBI service sometimes adds the rest of the Domain in email to the right. Perhaps adding the full within your filtering RLS will help and may be whats missing.
- lbendlin5 years agoSuper User
That's not entirely accurate:
USERNAME() will return the NT account domain\name on the desktop and the email on the service. Do not use!
USERPRINCIPALNAME() returns the email in both environments.