Forum Discussion

Netrelemo's avatar
Netrelemo
Helper IV
4 years ago

How do I get data from Azure AD?

Getting data from on prem Active Directory is easy: PowerBI > Get Data > Other > Active Directory. 

But that's on prem. 

 

Doing a web search tells me I need to develop my own custom connector. 

 

Back to PowerBI, I find this: 

PowerBI > Get Data > Azure > .... *nothing*

PowerBI > Get Data > Certified Connectors > .... *nothing*

 

Surely Azure Active Directory is a reasonably common thing? 

 

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Netrelemo - I think Azure AD relies on the Graph API.  I think you can use PowerShell to get the details and then import to Power BI.  Otherwise there is currently no Power BI connector.

  • Yep, Graph API looks like the way to go. And maybe OData then. Just can't believe it's so difficult