Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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

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?

1 ACCEPTED SOLUTION
Watsky
Solution Sage
Solution Sage

Syndicated - Outbound

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.

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.

Proud to be a Super User!

View solution in original post

3 REPLIES 3
Watsky
Solution Sage
Solution Sage

Syndicated - Outbound

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.

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.

Proud to be a Super User!

Syndicated - Outbound

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
Super User
Super User

Syndicated - Outbound

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)