Forum Discussion

imranamikhan's avatar
imranamikhan
Icon for Helper V rankHelper V
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 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

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

  • smishra99acres's avatar
    smishra99acres
    Icon for Helper I rankHelper I
    3 years ago

    Hav you got the solution? i am facing same issue

  • smishra99acres's avatar
    smishra99acres
    Icon for Helper I rankHelper I
    3 years ago

    Same issue facing how did you solve this issue.i am getting all data except that i own