How to get user full name from active directory

[vini_udenia]

Hi,

I'm implementing RLS and while doing so need to filter the data based on the User who has logged in. So that each user only sees his or her own records. The 2 DAX functions username() and userprincipalname() return the domain user name and the email address.

example:

username() returns AD\edwardh

userprincipalname() returns edward.hall@xxxx.com

What I need is the full name: Edward Hall for comparision to the data. How can this be extracted?

[GilbertQ]

Hi there

What you actually need is the edward.hall@xxxx.com

In the Power BI Service it ONLY uses the USERPRINCIPALNAME()

[vini_udenia]

Hi Gilbert,

Thansk for your reply but my data is following format:

SalespersonName             Country           Sales

-----------------------------------------------------

Edward Hall                      Singapore       10,000

Mark Twain                       UK                   20,000

On the query I want apply the filter [SalespersonName] = <Name of the user who is viewing the report>

USERPRINCIPALNAME() will return is edward.hall@xx.com which I can't equate to the Salesperosn Name. The email might not always have the user full name as well, For Mark email can be mark.t@xxx.com, so I cnat derive the Full Name from email address.

[GilbertQ · Accepted solution]

Hi there

What I would suggest doing is using the Active Directory connector and get all the users names into your data model.

After that you can then get their UPN and map them accordingly.

Here is a blog post explaining how to do this: https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security...

[vini_udenia]

That worked! Thanks Gilbert!

[GilbertQ]

Awesome thanks for letting us know!