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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
armchairexpert
Helper III
Helper III

Connecting Anonymously to Microsoft Graph

Hi,

 

I am trying to access graph.microsoft.com in Power BI to get the users.

 

armchairexpert_0-1599231665718.png

 

When I click OK, I get the following error message.

 

armchairexpert_1-1599231700599.png

 

But it never gives me a screen to select Anonymous. How can I select Anonymous?

 

Thanks.

 

1 ACCEPTED SOLUTION

@armchairexpert - Hang on, you want Azure AD Graph, not the security graph, got it. My bad. For what you want, I used OData connector to here: https://graph.microsoft.com/v1.0

 

And used Organizational User account for authorization.

Greg_Deckler_0-1599241174218.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

7 REPLIES 7
armchairexpert
Helper III
Helper III

@Greg_Deckler,

 

Yes, that worked. I used just  https://graph.microsoft.com/v1.0 instead of adding /users to it. 

 

Thanks for your help. Much appreciated. 👍

armchairexpert
Helper III
Helper III

@Greg_Deckler ,

 

I used both beta and v1.0. Same issue.

 

If I don't have access, then how can get the following when I run it on Microsoft Graph Explorer using the same account? This is live data from my organisation!

 

armchairexpert_0-1599240100086.png

 

 

@armchairexpert - Hang on, you want Azure AD Graph, not the security graph, got it. My bad. For what you want, I used OData connector to here: https://graph.microsoft.com/v1.0

 

And used Organizational User account for authorization.

Greg_Deckler_0-1599241174218.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
armchairexpert
Helper III
Helper III

@amitchandak , @Greg_Deckler ,

 

Thanks for your response.

 

When I try using Graph Security Connector, it says Access Forbidden.

 

armchairexpert_0-1599237429138.png

armchairexpert_1-1599237447685.png

 

When I use the OData Feed and Anonymous, it says couldn't authenticate credentials. Also tried Windows and Organizational Account with same message.

 

armchairexpert_2-1599237511946.png

 

This is surprising and frustrating as I am a Global Admin. It works fine when I use it in Postman and I can see all users in our organisation. 

 

 

With the Microsoft Security Graph connector, in the first drop down, did you choose the v1.0 versus beta?

Greg_Deckler_0-1599238265705.png

If you go through this wizard and get access denied, then you don't have the security juice to access the API.

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Community Champion
Community Champion

@armchairexpert - Try using the Microsoft Graph Security Connector built in to Power BI

Greg_Deckler_0-1599233229165.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

@armchairexpert , refer

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-graph-security

https://blog.mydock365.com/microsoft-graph-api-data-on-microsoft-power-bi

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.