How to show data from Azure active directory in Power BI report

[Anonymous]

Hi Experts,

I need to connect to Azure active directory in Power BI desktop and display the user data from AAD in Power BI reports. Is it achievable in Power BI?

[Watsky · Accepted solution]

Hey @Anonymous it would really depend on exactly what you're trying to capture from Azure AD but a lot of the information gets stored into Microsoft Graph https://developer.microsoft.com/en-us/graph/graph-explorer

This means that you would need to create a custom connector to access it. https://docs.microsoft.com/en-us/connectors/custom-connectors/define-blank . 

Here's a sample connector: https://github.com/Microsoft/DataConnectors/blob/0621c3d7e7cc4d32df2193e0d5ebfb488f344453/samples/MyGraph/MyGraph.pq

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

[Mogry]

Hi,

I like to get the users from an AAD group into a PBI report. Is there another way, without PowerApps/Automate, to do this?

Cheers

[parry2k]

@Anonymous you can use graph API to get AAD data. I don't have much knowledge but I know this is the route you can use to make it work.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡