Forum Discussion
RLS with username/email
Hello - i have an issue with RLS. First time using it, so might be a simple fix. I have a few tables in the model ALL which include a column that has an email address. (When i publish to PBI service, this username will match the email address in the table). When i create a role and filter all the tables to Email address column = Username(), no filtering happens.
Ideas?
Are you assigning users emails to the roles in the security option of datasets in the service?
7 Replies
I tried this and it still did not filter anything.
I created a measure just to test, showing (user=userprincipalname) and this does show the correct email address (which matches what it in all the email columns) when published to power BI service.
Are you assigning users emails to the roles in the security option of datasets in the service?
