Forum Discussion
imranamikhan
7 years agoHelper V
Row Level Security using User Principal Name (UPN)
Hi, I am trying to set up Row Level Security to restrict the data a user can view based on their e-mail address but I am having an issue. Context: Table A is what users have access to. Th...
- Anonymous7 years ago
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
Anonymous
7 years agoNot applicable
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?