Pulling AD userID

[Anonymous]

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.

[lbendlin · Accepted solution]

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]

Thanks,

I will check this.

Ya, I am trying to implement row level security.