Analytics · PowerShell + Graph

Copilot Interaction Report

Export Copilot interaction history from Microsoft Graph and build a self-contained HTML usage dashboard without Power BI.

View on GitHub

graph powershell dashboard

What it is

A PowerShell module and entry script that export per-user Microsoft 365 Copilot interaction history from Graph and render a self-contained HTML dashboard.

Why use it

Create an adoption and friction report without Power BI or a database.
Review users, sessions, surfaces, features, error rates, trends, and recent audited events.
Authenticate app-only with a client secret or certificate and rebuild reports from cached JSON.

How to use it

Register an Entra application and grant the documented application permissions with admin consent.
From PowerShell 7, run New-CopilotInteractionReport.ps1 with tenant, client, and secret or certificate parameters.
Open the generated copilot-report.html; use -SkipExport to rebuild from existing JSON.

Prerequisites

PowerShell 7 or later
Entra app registration
AiEnterpriseInteraction.Read.All, User.Read.All, and Organization.Read.All application permissions
Microsoft 365 Copilot licensed users