Retrieve usage metrics

Glenn Maxwell 14,371 Reputation points
2026-09-03T00:19:44.3+00:00

Hi All,

I’m looking to create a Viva Insights report for Copilot usage in our environment and integrate the available data with Power BI so that we can build and schedule a recurring report.

I would like to understand what Copilot usage metrics and data are available for reporting. Based on my understanding, we may be able to retrieve metrics such as:

  • Active Copilot users
  • Copilot actions/interactions
  • Copilot-assisted value
  • Meeting-related activity
  • Teams chats
  • Emails
  • Documents

Could someone please confirm which of these metrics are available through Viva Insights and can be integrated with Power BI? Also, are there any additional Copilot usage metrics or datasets that I may be missing? Please guide me.

Microsoft Copilot | Microsoft 365 Copilot | Development
0 comments
Answer accepted by question author
Copilot Workshop 80 Reputation points
2026-10-21T01:06:04.05+00:00

Two free sources cover most of what you listed, and they're built for different audiences:

  1. Microsoft 365 admin center Copilot usage report (Reports > Usage > Microsoft Copilot). It shows enabled users, active users, the active-user rate, adoption by app, and a per-user last-activity table over 7/28/90/180 days. Data for a day usually appears within about 48 hours. For a scheduled Power BI report, the same data is available through the Microsoft Graph Copilot usage reports API (getMicrosoft365CopilotUsageUserDetail), so you don't need manual CSV exports.
  2. Copilot Dashboard in Viva Insights. It covers readiness, adoption, impact and sentiment over a rolling 28 days (with up to about a 6-day delay), grouped by organization attribute, and it suppresses groups below the minimum group size. For the exact Viva metric names you can take into Power BI (Copilot actions by app, assisted hours, meeting/email/chat activity), see "Advanced analysis metric descriptions" on Microsoft Learn.

Before you build it:

  • User names are concealed by default in the admin center reports and the Graph report API. Clearing Conceal user, group, and site names in all reports (Settings > Org settings > Services > Reports, Global Administrator) is tenant-wide and affects every usage report, so check with HR/legal first if identifiable data is a concern.
  • The two sources won't match exactly (different windows, latency and populations). Pick one as the official number in the report and label it.
  • Usage counts show whether people use Copilot, not whether it helps them. A short pulse survey alongside the report fills that gap.

Docs: "Microsoft Copilot usage report", "Microsoft 365 reports show anonymous instead of actual user names" and "Connect to the Microsoft Copilot Dashboard" on Microsoft Learn.

Disclosure: this answer was drafted with AI assistance and reviewed by me.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-09-03T00:20:06.3633333+00:00

    Yes. Viva Insights supports Copilot reporting that can be used with Power BI through Advanced Reporting and prebuilt Power BI templates.

    The metrics and report areas available from the provided context include:

    1. Active Copilot users
      • Available in the Microsoft Copilot impact report summary.
      • The summary includes the total number of active Copilot users.
    2. Copilot actions / interactions
      • Available as Total Copilot actions taken.
      • The impact report summary also includes the total number of Copilot actions taken.
      • Exported metrics also include app-level actions such as:
        • Copilot actions taken in Microsoft Copilot app
        • Copilot Chat
        • Excel
        • Outlook
        • PowerPoint
        • Teams
        • Word
        • Edge
      • Additional app-specific interaction metrics include prompts submitted in Word, Excel, and PowerPoint, and compose chat message actions taken using Copilot in Teams.
    3. Copilot-assisted value
      • Available as Copilot assisted hours.
      • This is described as the estimated number of hours users were assisted by using Copilot.
    4. Meeting-related activity
      • Supported in the Microsoft Copilot impact report under the Meetings section.
      • The Copilot Dashboard Impact tab also shows workplace patterns and collaboration trends, including changes such as time spent in meetings.
    5. Teams chats
      • Supported in the Teams chat section of the Microsoft Copilot impact report.
      • Copilot Chat metrics are also available, including Copilot Chat prompts submitted.
    6. Emails
      • Supported in the Email section of the Microsoft Copilot impact report.
      • Exported metrics also include Copilot actions taken in Outlook.
    7. Documents
      • Supported in the Documents section of the Microsoft Copilot impact report.
      • Exported metrics include actions and prompts for Word, Excel, and PowerPoint.

    Additional Copilot metrics available from the context:

    • Copilot habitual users
    • Copilot novice users
    • Copilot power users
    • Copilot other users
    • Days of active Copilot Chat usage
    • Days of active Copilot Chat (legacy web) usage
    • Total Copilot active days
    • Copilot Chat “Ask and find” prompts submitted

    For Power BI integration:

    • Viva Insights Advanced Reporting supports both pre-configured Power BI report templates and customizable queries.
    • The Microsoft Copilot impact report is populated in Power BI by running the predefined Microsoft Copilot impact query in Viva Insights.
    • Advanced Reporting supports selecting from more than 100 Copilot metrics and customizing filters for more granular analysis.

    Prerequisites called out for Power BI reporting:

    • The report requires the user to be assigned the Insights Analyst role in Viva Insights and be licensed with Viva Insights.
    • Power BI Desktop June 2022 or newer is required.
    • Employees included in the measured population need Microsoft Copilot licenses and Microsoft Viva Insights licenses.

    If the goal is a recurring report, the supported path in the context is to use Viva Insights Advanced Reporting with the predefined or custom queries and then build the report in Power BI.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.