Microsoft 365 admin center Copilot reports show how your organization uses Copilot across Microsoft 365 apps. You can see adoption trends, active user counts, and feature usage. Without these reports, administrators cannot measure Copilot return on investment or identify training needs. This article explains how to access the reports, interpret the data, and export usage information for further analysis.
Key Takeaways: Using Admin Center Copilot Reports
- Microsoft 365 admin center > Reports > Usage > Copilot: Central location for all Copilot usage data across your tenant.
- Export to CSV button: Downloads raw usage data for custom analysis in Excel or Power BI.
- Date range filter (7, 30, 90, 180 days): Adjusts the reporting window to match your review cycle or billing period.
Understanding Copilot Reports in the Admin Center
The Copilot report is part of the Microsoft 365 admin center usage analytics suite. It collects telemetry from Copilot interactions in Word, Excel, PowerPoint, Outlook, Teams, and Microsoft 365 Chat. The report shows aggregated data only. No individual user content or conversation text is included.
The report answers three core questions. First, how many people in your organization use Copilot each day. Second, which apps get the most Copilot activity. Third, whether usage is growing or declining over time.
Prerequisites to View the Reports
You need one of these admin roles to access the report: Global Administrator, Reports Reader, Usage Summary Reports Reader, or Exchange Administrator. The report appears only if at least one user in your tenant has a Copilot license assigned. The data refreshes every 24 to 48 hours.
Steps to Access and Use Copilot Reports
- Sign in to the Microsoft 365 admin center
Go to admin.microsoft.com and sign in with your admin credentials. Use the Global Administrator or Reports Reader account for full access. - Navigate to the Reports section
In the left navigation pane, select Reports. Then choose Usage from the submenu. - Open the Copilot report
On the Usage page, scroll down to the Copilot card. Click View report to open the detailed Copilot usage dashboard. - Set the date range
At the top of the report, use the date range dropdown. Select 7 days, 30 days, 90 days, or 180 days. The default is 30 days. The chart and table update immediately. - Review the active user chart
The line chart shows daily active users who performed at least one Copilot action. Hover over any data point to see the exact user count for that day. - Examine the app-level breakdown
Below the chart, the table lists each Microsoft 365 app. Columns show total active users, total Copilot actions, and the percentage change from the previous period. Sort any column by clicking its header. - Filter by product or platform
Click the Filter button above the table. Choose specific apps like Word or Teams. You can also filter by Windows, Mac, or mobile platforms. Click Apply to refresh the data. - Export the report to CSV
Click the Export button at the top of the report. Select Export usage data. A CSV file downloads to your computer. Open it in Excel or Power BI for custom pivot tables and charts.
Common Mistakes and Report Limitations
The Report Shows Zero Active Users Even Though Users Have Copilot
This happens when licenses are assigned but users have not signed in to the Copilot service yet. Copilot must be enabled in the Microsoft 365 admin center at Settings > Org settings > Copilot. If the toggle is off, all user activity is blocked. Turn it on and wait 24 hours for data to appear.
Data in the Report Does Not Match Internal Surveys
The admin center report counts only actions that generate a Copilot response. Actions like opening the Copilot pane but not sending a prompt are excluded. If your internal survey asks about general awareness, the numbers will differ. Use the exported CSV to filter by action type for a closer match.
Cannot See the Copilot Report Card in Usage
The Copilot card appears only when at least one user has performed a Copilot action in the last 30 days. If no one has used Copilot yet, the card is hidden. Assign a test license to a user, run a prompt in Word or Teams, and check the report after 48 hours.
Copilot Report Views: Admin Center vs Power BI Template
| Item | Admin Center Report | Copilot Power BI Template |
|---|---|---|
| Access method | admin.microsoft.com > Reports > Usage | Download from Microsoft Download Center, import to Power BI |
| Data granularity | Aggregated by app and date | User-level with department and location dimensions |
| Refresh schedule | Every 24-48 hours | Manual refresh in Power BI service |
| Custom visualization | Fixed line chart and table | Full Power BI editing: slicers, maps, drill-through pages |
| Export options | CSV only | Power BI export to PDF, Excel, PowerPoint, or live dashboard |
| License requirement | Any Microsoft 365 admin license | Power BI Pro or Premium per user license |
The admin center report is best for a quick weekly check. The Power BI template is better for deep analysis across departments or custom time ranges. Use the CSV export from the admin center as a data source for the Power BI template if you do not have direct API access.
You can now access the Copilot report in the admin center, filter by date and app, and export data to CSV. Next, try the Power BI Copilot template for department-level adoption tracking. Set a weekly calendar reminder to review the report so you catch usage drops early.