Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
balajimrb
Frequent Visitor

How to obtain organization data into Power BI?

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

1 ACCEPTED SOLUTION
JirkaZ
Solution Specialist
Solution Specialist

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

View solution in original post

3 REPLIES 3
JirkaZ
Solution Specialist
Solution Specialist

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

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
Solution Specialist
Solution Specialist

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.