Forum Discussion

imranamikhan's avatar
imranamikhan
Helper 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
Super 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

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