Copilot usage from the Microsoft 365 apps usage report.

The M365 apps usage report includes Copilot usage alongside the other apps. This downloads and parses the CSV.

Permissions

Requires delegated permission Reports.Read.All.

Reference

• https://learn.microsoft.com/en-us/graph/api/reportroot-getm365appusercounts

View source

import argparse
import csv
import io

from office365.graph_client import GraphClient
from tests.settings import client_id, client_secret, tenant


def main():
    parser = argparse.ArgumentParser(description="Copilot usage from the M365 apps report")
    parser.add_argument("--period", default="D7", help="Report period (D7/D30/D90/D180)")
    args = parser.parse_args()

    client = GraphClient(tenant=tenant).with_client_secret(client_id, client_secret)
    data = client.reports.get_m365_app_user_counts(args.period).execute_query().value

    rows = list(csv.DictReader(io.StringIO(data.decode("utf-8"))))
    print(f"M365 apps user counts ({args.period}) — {len(rows)} rows (includes Copilot):")
    for row in rows[:20]:
        print(dict(row))


if __name__ == "__main__":
    main()

---

← Back to Microsoft 365 Copilot