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
Did you ever this this resolved? I am wondering if RLS/View As Roles is buggy in the latest PBI Desktop release? I have a lot of experience with RLS and using UserPrincipalName() in roles. However, now, when I use my own user, the security role works fine. But as soon as I use View As Role with any value, it just returns all the data. This is obvious not how it is supposed to work.
Is anyone else have issues like this with the most recent release?
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?
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 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
