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
damomac85
Frequent Visitor

Azure Active Directory User Profiles

Does anyone know if its possible to connect to AAD to pull user profile info using power BI ?

 

e.g. Name, Email, Job Title, Department and manager ?

3 REPLIES 3
lbendlin
Super User
Super User

Yes, there is an Active Directory connector in Power BI. Specify the domain and then select the object as needed. Be prepared for LONG waits, especially in larger companies. That thing is SLOW.

Anonymous
Not applicable

@damomac85 , did you figure out how to do this? I'm trying to do the same thing and can't find any documentation on it...

Hi @Anonymous,

 

I achived this by using a power bi workflow to connect to AD and refresh the data over night, as this informaion is not transactional based so does not update very oftern.

 

I then joined to the datasource using email address. This might not be the best/most efficient way to do this but it was enought to cover my requirement.

 

 

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.