Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Pulling AD userID

Hi,

 

I have a table in my database with userid and the departments associated with it.

What I need to do is, get the AD user logged on to Power BI and match it with my table in database and display only specific departments to that user.

Any idea how do I get the AD user id.

Online, I could only find content related to bringing the AD data into powerBI. I want to do it without pulling the whole of AD data.

 

Thanks in advance.

 

Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    The USERPRINCIPALNAME() function in DAX gives you the email address of the user.  What you are trying to do sounds a lot like RLS (Row Level Security) - have you looked into that?

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    The USERPRINCIPALNAME() function in DAX gives you the email address of the user.  What you are trying to do sounds a lot like RLS (Row Level Security) - have you looked into that?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks,

      I will check this.

      Ya, I am trying to implement row level security.