topic Re: Azure Active Directory User Profiles in Developer

Azure Active Directory User Profiles

damomac85 — Tue, 22 Oct 2019 14:26:50 GMT

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 ?

Re: Azure Active Directory User Profiles

Anonymous — Mon, 15 Jun 2020 21:35:32 GMT

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

Re: Azure Active Directory User Profiles

lbendlin — Mon, 15 Jun 2020 23:37:14 GMT

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.

Re: Azure Active Directory User Profiles

damomac85 — Tue, 16 Jun 2020 13:22:11 GMT

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.