CODEWITHSUNDEEP
office365microsoft-graph-apipowerbi
Gidi
Gidi

Reputation: 13

Possible to call all employees calendars in Power BI using Microsoft Graph?

With our organization, we use Office 365. We would like to use all employees calendars to visualize capacity in Power BI.

Within Power BI (using get data -> OData feed) I can retrieve one of my colleague's calendar events by calling Microsoft Graph with the following command:

/v1.0/users/[email]/calendar/events

Is it also possible to load the events of all employees calendars directly into Power BI using Microsoft Graph?

(All users can be called via /v1.0/users, but even better: all relevant users can be called via a group we already have: /v1.0/groups/[group_id]/members)

Upvotes: 1

Views: 1344

Answers (1)

Marc LaFleur
Marc LaFleur

Reputation: 33114

This isn't a supported scenario. You would need to separately collect the events from each calendar under each user, stitch them together, and store the result. Assuming you have a small enough organization to avoid running into the API's throtting thresholds, it might be doable. That said, keeping your data in sync with all of those calendars over time will present additional challenges.

Upvotes: 1

Related Questions