It’s Nice to be GA, but What Can You Do with the Copilot Usage Report API?

MC877369 first appeared in August 2024 to announce the availability of Microsoft 365 Copilot usage data through the Graph usage reports API (Microsoft 365 roadmap item 396562). The most recent update (6 Oct 2025) sets out a new timeline for general availability of the APIs, which is now expected to roll out in late October 2025 for worldwide completion in late November 2025. Microsoft doesn’t say why the latest delay occurred or why it’s taken so long to move the API from preview to GA.

Still at the Beta Endpoint

Although the Copilot usage report API is heading for general availability, it’s still only accessible through the beta endpoint. There’s nothing wrong with that, providing the API works. Normally, Microsoft Graph APIs accessible through the beta endpoint are under active development to solve performance or reliability problems, or to complete the features necessary to move to production (V1.0) status.

Using the Copilot Usage Report API

I first looked at the API in September 2024 and concluded that most value can be derived from the Copilot user activity detail API. Knowing what apps people use Copilot in is valuable information if you want to do things like:

• Knowing what departments Copilot is being used in and those that need a little help to get going. By including user data from Entra ID with Copilot usage data, we can slice and dice the usage data to generate additional insights (Figure 1).

• Look for user accounts with expensive ($360/year) Microsoft 365 Copilot licenses and automatically remove underused licenses so that the licenses can be reallocated to people who might use them more. The folks who lose the Microsoft 365 Copilot licenses might be happy with the no-charge Microsoft Copilot chat capability. Or they might be the folks in the company who are using ChatGPT and other AI tools instead of Copilot.
• A variation on the theme is to integrate Microsoft 365 audit data with Copilot usage report data to drill down into what people are doing with Copilot. The intention once again is to weed out underused Microsoft 365 Copilot licenses so that others might be assigned those licenses.
• I have a script to create a composite picture of user activity across multiple workloads. It would be easy to add the Copilot usage data to the mix.

Example PowerShell scripts are available to demonstrate the principles explored in each scenario. The point is that usage data is interesting in its own right, but it becomes more powerful when combined with other easily-accessible Microsoft 365 data sources about user activity.

Remember to allow full display of usernames and other information for the report data. If you don’t, the usage data will be obfuscated (concealed) and won’t be able to match up with data from other Microsoft 365 sources.

Other Usage Report APIs

Microsoft 365 supports a bunch of other usage reports APIs for different workloads. Not all workloads featured in the Microsoft 365 admin center are available through a Graph API (like Forms, Project, Visio, and Viva Learning). The same is true for some sub-reports (like Copilot agents). However, there’s enough data available to be able to build a good picture of how people use Microsoft 365 across the board.

The issue with reporting SharePoint URLs (first reported in September 2023) persists. Some security issue is apparently cramping Microsoft’s ability to include site URLs in the site activity report (powered by the getSharePointSiteUsageDetail API), which means that the usage data returned for a site looks like this:

Report Refresh Date      : 2025-10-07
Site Id                  : 66bbf297-2f09-43ec-ab94-9333deacf769
Site URL                 :
Owner Display Name       : Project Haycock Owners
Is Deleted               : False
Last Activity Date       : 2025-05-23
File Count               : 375
Active File Count        : 131
Page View Count          : 0
Visited Page Count       : 0
Storage Used (Byte)      : 110786012
Storage Allocated (Byte) : 27487790694400
Root Web Template        : Group
Owner Principal Name     : projecthaycock@office365itpros.com
Report Period            : 180

The Site Id can be used to find the website URL:

(Get-MgSite -SiteId '66bbf297-2f09-43ec-ab94-9333deacf769').WebUrl
https://office365itpros.sharepoint.com/sites/projecthaycock

It’s a mystery why Microsoft won’t or can’t fix this irritating issue. Just one of those cloud mysteries…