Forum Discussion
Solved
Microsoft Graph Data Access
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?
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/
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?
lbendlin I'm trying to build a report of calendar events with the users in my department.
Does it work in Graph Explorer?
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.
yep. Officially only /groups is supported.