Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

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

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

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!

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

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.