Azure Active Directory User Profiles

damomac85 · ‎10-22-2019

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 ?

lbendlin · ‎06-15-2020

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 · ‎06-15-2020

@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...

damomac85 · ‎06-16-2020

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.