Forum Discussion
Row Level Security using User Principal Name (UPN)
Never mind. I figured out what I was doing wrong. I think part of my brain is already floating on the lake, totally NOT thinking about Power BI. :-)
I just forget to both click "View As" and also select the role. Again, total brain fail I am blaming on the upcoming holiday.
Thanks! Scott
I ran into odd behavior if the person I view as was a member of the workspace. I think it's because the user can get to the dataset that RLS doesn't filter it down. Perhaps try it as a user you have just shared the report with?
I am testing in PBI Desktop. And I just did one more test. The role is straigtforward - '[e-mail] = userprincipalname()' and then I entered a valid email into the View As Role textbox '[email protected]'. This still (incorrectly) returned all the values in the table, not just the ones I own. I then changed the security role to '[e-mail] = '[email protected]"' and when I applied it, only the records owned by that email came back, as is supposed to happen.
Again, I think it is a bug.
Hav you got the solution? i am facing same issue
Same issue facing how did you solve this issue.i am getting all data except that i own
