How to obtain organization data into Power BI?

[balajimrb]

Hi,

I have a data field containing outlook alias ID of users, i want to lookup the email address or name of these users from the their organizational profiles. How to do this?

Regards,

Balaji R

[JirkaZ · Accepted solution]

@balajimrb There's Active Directory connector available. So you need to use that to get that sort of info.

[balajimrb]

It did work. Thanks @JirkaZ is there a way to obtain manager's name? i see a lot of tables inside my AD url. not sure which one will have manager's name

[JirkaZ]

@balajimrb The user info is usually in the OU structure. There should also be the info about the manager.