015 - Calling Graph Reports API Using Power Automate

Microsoft provides an out-of-box Power BI report for organizations looking to gain an understanding of their Microsoft 365 usage. While these reports are extremely useful, you have less control over the underlying data model and the data is based upon monthly usage for the past 12 months.

There may be situations when you want more timely access to data and want to persist it for more than 12 months. The Microsoft Graph Reports API exists that allows developers to access organizational-level data for the past 7y/30/90/180 days. Because you have direct access to this data, you can store this information in your own data store, such as CDS or Azure SQL.

In this video, I will demonstrate how you can create your authentication parameters and use the HTTP action, in Power Automate, to access Microsoft Teams Usage data using the Microsoft Graph Reports API.

Links:

Community Partnership:

[ankushghaiable]

Great video. We can replace json with Csv and then it will fetch a csv. I am stuck with how to schedule a task to mail this csv to a bunch of people. Do you already have a video on that? On how to email as an attachment, of what you fetch from Graph API?

[maheshkhiste]

Good video, i was thinking of using Graph Reports API for one of my production use case but then i saw its beta. I believe v1.0 provides csv output and not sure how that can be handled in PowerAutomate