Forum Discussion

KJanssens's avatar
KJanssens
Helper II
3 years ago
Solved

Recommended method to get AAD users into powerquery?

Dear,

what is the current recommended way to get an up-to-date list of all Azure Active Directory users (with their first name, last namen principal name)?

I have read that the Graph API is not recommended by Microsoft; the Active Directory connector works only with on-premise AD; writing scheduled scripts to export to csv and read them in power query seems overkill to me...

I am looking for a decent solution for months now and I can't imagine it should be that hard to get this list into Power BI for analysis...

Thanks,

Koen

Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    I agree it is harder than it should be. The simplest way may be to create a simple flow in Power Automate. The first two steps are shown here. You could add a Parse JSON step and then write to a CSV on SharePoint and then pull that into Power BI.

     

    Pat

1 Reply

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    I agree it is harder than it should be. The simplest way may be to create a simple flow in Power Automate. The first two steps are shown here. You could add a Parse JSON step and then write to a CSV on SharePoint and then pull that into Power BI.

     

    Pat