Forum Discussion

damomac85's avatar
damomac85
Frequent Visitor
6 years ago

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 ?

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      damomac85
      Frequent Visitor
      6 years ago

      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.

       

       

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    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.