Microsoft Graph Data Access

[istduncan-cohp]

I want to build a report using Microsoft Graph API, but I have noticed this may be something Power BI cannnot access.  Has anyone else had this issue? 

[istduncan-cohp]

I did find another example that may help in the pagination .  

[lbendlin]

it's not that black and white. Power Query can access some of the Graph endpoints  but not all.  What are you trying to accomplish?

[istduncan-cohp]

@lbendlin I'm trying to build a report of calendar events with the users in my department.  

[lbendlin]

Does it work in Graph Explorer?

[istduncan-cohp]

Yes.  There are two endpoint I will need the first is /users?$filter=department in ('DepartmentName') and users/'UserID'/calendar/events.

From the looks of it, I may need to look for an alternative option.

[lbendlin]

yep. Officially only /groups is supported.

[istduncan-cohp · Accepted solution]

@lbendlin Both endpoints works int Graph Explorer, it is just a matter of combining the 2.   It looks like it could b made possible by using the following: 

https://techpeanuts.wordpress.com/2020/05/28/connecting-power-bi-to-microsoft-graph/ 

[lbendlin]

making it work in Graph explorer is required but not sufficient.  They can still block certain calls in other systems. Let me know what you find out.