The hours and value Microsoft 365 Copilot and agents deliver, as an app or a Power BI report.
All reports and guides can be found on the Analytics Hub.
Also see Analytics Hub for Microsoft Copilot: one installer sets up an app on Microsoft Fabric or Azure that shows Copilot and agent adoption, value, consumption and governance in one place. It includes the ValueLens report.
Found this useful? ⭐ Star this repo to help others discover it!
Before you start ↓ · Choose your path ↓ · After setup ↓ · Watch the demo ↗
| The app | The Power BI report |
|---|---|
 |
 |
All screenshots use synthetic sample data. Every name in them is invented.
- Watch the demo (2 minutes). What the dashboard shows, page by page.
- Watch the Fabric setup. From a new app registration to a self-refreshing report. Or download the video.
- An app that shows how your organisation uses Microsoft 365 Copilot and agents.
- The hours and value that Copilot and agents deliver, by team, tool and task.
- A Power BI report with the same numbers, if you prefer Power BI.
- Read the disclaimer. This isn't the official Copilot report. You own the data it extracts.
- Licences. App viewers need Power Apps Premium or Copilot Credits. Report viewers need Power BI Pro.
- A place for the data. A Fabric capacity (F2 or larger, or a free trial). Or an Azure subscription, a SharePoint library, or just your PC.
- Admin help. A Global Administrator approves read-only Microsoft Graph permissions (not needed for Local CSV). A Power Platform Administrator allows managed apps.
- Tools. Windows 10 or 11. Power BI Desktop, June 2024 or later.
For the app: Node.js 24.11 or later, Git and the
mstool.
The full checklist, by who does what, is in Before you start. Every permission is explained in Permissions.
| Path | Who it suits |
|---|---|
| Installer (recommended, fastest) | Most people. It asks a few questions, then sets everything up for you. |
| Manual (step by step) | People who want to control each step, or can't run the installer. |
Coming soon: a ValueLens installer (#216). Until then, use the Analytics Hub installer. It sets up ValueLens on Fabric or Azure, with an app. It's a work in progress, so try it in a test tenant first.
- Send each admin their part of the checklist.
- Download AnalyticsHubInstaller.exe. If Edge or Windows warns you, see Check the download.
- Open it. After about a minute, it opens in your browser. Keep its window open.
- Choose Set up Analytics Hub and sign in with your work account.
- Answer the questions. Pick Fabric or Your Azure subscription, then the data you want. Choose No for advanced settings to take the defaults.
- Approve the plan. Nothing is created until you do. Setup takes about 15 minutes.
- Check it worked. Open the app link it gives you. The first data arrives about 25 minutes later.
More detail: on Fabric, on Azure, or the installer reference.
The app first, then the data behind it.
-
Try the app. Open
app/download/ValueLens-App.html, choose Download raw file, and open it in Edge or Chrome. It shows sample data. -
Collect your data. Pick one path and follow its README.
Path You need 1. Fabric (recommended) A Fabric capacity, F2 or larger, or a free trial 4. SharePoint Power BI Pro and a SharePoint library 5. Local CSV Power BI Desktop only. Sample data is included 2. Azure is set up by the installer only.
-
Deploy the app. An admin turns on two settings. Then you deploy it with the
mstool. See Deploy the app. -
Share the app. Viewers open it, choose Change data and pick the CSV files from step 2. See which files the app reads.
-
Optional: publish the Power BI report. Every path includes the report template.
-
Optional: add extras, such as credit consumption or Agent Evaluator. See Optional extras.
- Check it worked. The app no longer says Sample data, and it shows your organisation.
- Keep it fresh. Fabric refreshes on the pipeline's schedule. SharePoint refreshes daily. Local CSV refreshes when you export again. Installer users can open the exe again for status and repairs.
- Read the numbers. Use the report interpretation guide (PDF) and how the value is calculated.
- Get help. Open an issue or see Support.
Disclaimer
- This isn't the official Copilot report. The official sources are the Microsoft 365 admin center Copilot usage reports and the Viva Insights Copilot Dashboard. ValueLens takes its Copilot figures mainly from the Purview audit log, which isn't the authoritative source, so its numbers may not always match those reports exactly.
- You're responsible for the data once it's extracted. ValueLens copies data into your own Fabric, Azure, Dataverse, SharePoint or CSV files. The retention, deletion and other policies you set in Purview, Microsoft 365, Entra ID, Dataverse and the other sources don't apply to those copies. Managing that data and meeting your organisation's requirements is up to you.
Usage and compliance. While this tool helps customers understand the business value of their AI usage data, Microsoft has no visibility into the data customers input, nor control over how the template is used. Customers are solely responsible for ensuring their use complies with all applicable laws and regulations (including data privacy and security). Microsoft disclaims all liability arising from use of this template.
This is an experimental template with Purview audit logs as the primary source. Audit logs provide visibility into Copilot/agent interactions but are not intended as the sole source of truth for licensing or full‑fidelity reporting. Not supported through Microsoft support channels — please open an issue in this repo.
The Power BI report and add-ons
Each data path also gives you the ValueLens Power BI report.
- Just want a look? Use 5. Local CSV with its sample data. It takes two minutes and needs no access to your tenant.
- Opening a template? Use Power BI Desktop from June 2024 or later. In older releases, some charts and cards on the Habit Formation page show errors (why). Reports in the Power BI service and Fabric aren't affected.
- Report interpretation guide. A page-by-page guide to the 15 report pages, with the key questions each one answers. Open the guide (PDF).
Optional add-ons:
- Credit consumption and cost: each path has an
Add Credit Consumptionfolder. In Fabric, set it up by hand. - Copilot Studio agent conversations: in Fabric, set up Agent Evaluator by hand.
- Shadow AI and agent risk: in Fabric, run the Defender notebook. It reads Microsoft Defender, needs Defender for Endpoint P2 or Defender for Cloud Apps, and fills the Shadow AI section of the Analytics Hub app's Governance page (details).
Other ways to host the app: the Fabric App
You can host the dashboard in your own Fabric workspace instead, as a Fabric App (also in preview). Instead of the managed app settings, it needs a workspace on Fabric capacity (F2 or larger, or a trial; My workspace won't work) and the Fabric Apps (preview) tenant setting.
- Analytics Hub app: queries your published ValueLens semantic model live, as the person viewing it, so row-level security applies. The installer deploys it. It also needs the Semantic Model Execute Queries REST API tenant setting.
fabric-app/: the app's design, reading your published ValueLens and Consumption Central semantic models live, as the person viewing it. It keeps no copy of your data. Deploy ValueLens alone (npm run deploy:vl), Consumption Central alone (npm run deploy:cc), or both (npm run deploy:both). Add--dry-runfirst to see which models it found. It also needs the Semantic Model Execute Queries REST API tenant setting. The folder is kept identical in the Consumption Central repo. Fabric App details →- The app, in Fabric: the same
app/code, reading the same CSV files, hosted in your workspace. See As a Fabric App.
Troubleshooting
- Installer: Troubleshooting.
- Fabric notebooks: An audit window keeps failing.
- SharePoint: Troubleshooting.
- Local CSV: Troubleshooting.
- The app: Deploy the app covers the admin settings, licences and timeouts.
Reference
Archived options
- Power Automate + Dataverse, path 3, was archived on 23 October 2026. Existing installs keep running, but it's no longer supported and gets no updates. For a new install, choose another path.
- Older report templates are kept in
archive/for reference.