topic Re: How to Retrieve Data for Copilot Adoption & ROI Dashboard in Developer

How to Retrieve Data for Copilot Adoption & ROI Dashboard

Mmoustaqssa — Thu, 02 Apr 2026 09:30:29 GMT

Hi everyone,

I’m currently working on building a dashboard similar to a Copilot Adoption & ROI Cockpit and I’m trying to understand how to retrieve the underlying data for the following metrics:

Assigned licenses / active Copilot users
Copilot usage (interactions, hours saved, etc.)
Usage segmentation (high vs occasional users)
Satisfaction metrics
Business value / ROI (hours saved, savings by business line)

What is the best way to retrieve and centralize this data?

Thanks

Re: How to Retrieve Data for Copilot Adoption & ROI Dashboard

Zanqueta — Thu, 02 Apr 2026 10:15:40 GMT

Hi @Mmoustaqssa.

I am not entirely certain of the exact technical architecture you intend to use, but the metrics you mention correspond directly to data exposed through the Microsoft 365 Admin Centre, the Microsoft Graph Reports API, and the Microsoft 365 Usage Reports. In enterprise contexts, the most reliable approach is to retrieve this information through the Graph API and centralise it using a structured data pipeline (for example, Fabric or Synapse).

Recommended source: Microsoft Graph (Directory and Reports APIs)

Recommended Architecture for Centralisation:

Microsoft Graph → Data Factory (or Fabric pipelines) → Lakehouse (Delta) → Dataflows → Power BI semantic model → Dashboard

Re: How to Retrieve Data for Copilot Adoption & ROI Dashboard

Mmoustaqssa — Thu, 02 Apr 2026 10:50:19 GMT

Thanks for your answer, very helpful.

I have a quick follow-up:What are the prerequisites to retrieve this data through Microsoft Graph?

Re: How to Retrieve Data for Copilot Adoption & ROI Dashboard

v-dineshya — Mon, 06 Apr 2026 08:12:07 GMT

HI @Mmoustaqssa ,

Thank you for reaching out to the Microsoft Community Forum.

Please refer below prerequisites to retrieve this data through Microsoft Graph.

1. At least one user must have a Microsoft 365 Copilot license assigned. Copilot usage APIs return no data if Copilot is not enabled in the tenant.

Note: Copilot usage reporting via Graph is available only in Public cloud.

2. Copilot data is exposed via Microsoft Graph Reports APIs, currently under:

/reports/getMicrosoft365CopilotUsageUserDetail
/reports/getMicrosoft365CopilotUserCountSummary
/reports/getMicrosoft365CopilotUserCountTrend

Note: These APIs are currently in /beta, return aggregated usage data and support a maximum of 180 days history.

3. Microsoft Graph permissions, you must grant Microsoft Graph – Reports.Read.All

4. Entra ID app registration, you must register an application in Microsoft Entra ID with:

a. Microsoft Graph --> Reports.Read.All
b. Admin consent granted tenant‑wide
c. Client secret or certificate configured

Note: This is mandatory for Azure Data Factory, Fabric pipelines, Synapse and Automated workloads.

Please refer below link.

reportRoot: getMicrosoft365CopilotUsageUserDetail - Microsoft Graph beta | Microsoft Learn

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

Re: How to Retrieve Data for Copilot Adoption & ROI Dashboard

v-dineshya — Thu, 09 Apr 2026 11:56:49 GMT

Hi @Mmoustaqssa ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

Re: How to Retrieve Data for Copilot Adoption & ROI Dashboard

v-dineshya — Mon, 13 Apr 2026 05:20:58 GMT

Hi @Mmoustaqssa ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh