microsoft/AI-in-One-Dashboard

microsoft/AI-in-One-Dashboard

Description: AI-in-One Dashboard Power BI template for comprehensive AI usage analytics

Language: PowerShell

License: MIT

Stars: 71

Forks: 17

Open issues: 0

Created: 2025-10-17T11:32:12Z

Pushed: 2026-07-20T12:50:57Z

Default branch: main

Fork: no

Archived: no

README:

🤖 AI-in-One Dashboard — Rollup Edition

This folder contains the AI-in-One Dashboard (Rollup edition) Power BI template, available in two editions: a flexible 3-in-1 auto-detect edition (reads local, SharePoint, or OneLake files) and a SharePoint-only (PBI-SharePoint) edition built for automatic scheduled refresh in the Power BI Service. Both deliver the same comprehensive insights into Microsoft Copilot and Agent adoption, empowering AI and business leaders to make informed decisions about AI implementation, licensing, and enablement strategies — and both load dramatically faster than previous versions thanks to a new pre-processed file format. See Which edition should I download to pick the right one.

---

> ## 🟦 IMPORTANT — Required input file format > > This template requires pre-processed rollup files — it cannot read raw Purview CSVs, raw Entra exports, or files from any other unprocessed source. Pointing the template at raw files will result in load failures or blank visuals. > > The recommended way to produce these files is the PAX script. See [📦 What is PAX?](#-what-is-pax) below for what PAX is and where to get it. > > Customers who export raw Purview and Entra data through a method other than PAX can use the standalone processor script in the [scripts/](scripts/) folder to produce the same rollup files. See the ⚙️ Standalone processor section below.

---

📸 Dashboard Preview

See the dashboard in action:

!AI-in-One Dashboard animated preview

---

🧭 Which edition should I download

This Rollup release ships in two editions that share the *exact same pages, visuals, and numbers*. They differ only in where they read your input files from and whether the Power BI Service can refresh them on a schedule. Pick one:

| | Rollup Edition (3-in-1, auto-detect) | Rollup Edition — PBI-SharePoint | |---|---|---| | ⬇️ Download | [AIO Dashboard - Rollup Edition](https://github.com/microsoft/AI-in-One-Dashboard/raw/main/AIO%20Dashboard%20-%20Rollup%20Edition%20-%202026-06-25.pbit) | [AIO Dashboard - Rollup Edition - PBI-SharePoint](https://github.com/microsoft/AI-in-One-Dashboard/raw/main/AIO%20Dashboard%20-%20Rollup%20Edition%20-%20PBI-SharePoint%20-%202026-06-25.pbit) | | Input file locations | Local path, SharePoint URL, _or_ OneLake URL — auto-detected for each parameter | SharePoint URLs only (each input is validated as a SharePoint URL) | | Best for | Power BI Desktop analysis, quick local trials, OneLake/Fabric, or any mix of the above | Publishing to the Power BI Service when you want automatic scheduled refresh | | Scheduled refresh in the Service | ❌ Not supported _(see below)_ | ✅ Supported — no Gateway needed | | Manual / on-demand refresh | ✅ In Desktop (and on-demand in the Service) | ✅ |

Why are there two editions

The Power BI Service decides whether it can schedule a dataset by statically inspecting how it connects to its sources — *before* it ever runs the query. A source whose location is computed at runtime — which is exactly how the 3-in-1 edition stays flexible enough to accept a local path or a SharePoint URL or a OneLake URL — is classified as a dynamic data source, and the Service disables scheduled refresh for the entire dataset when one is present. No M arrangement avoids this while keeping that flexibility; it's a platform rule, not a template bug.

The PBI-SharePoint edition gives up that flexibility on purpose: every input is read through a single, static SharePoint connector that the Service is happy to schedule. That one change is the only difference under the hood — the report itself is identical.

Rule of thumb

• Exploring in Power BI Desktop, or your files are local / on OneLake → 3-in-1 edition.
• You want the report to refresh itself on a schedule in the Service and your files are on SharePoint → PBI-SharePoint edition.
• Your files are on OneLake/Fabric and you need scheduled refresh → use the dedicated Fabric edition in [Classic Editions/3. Fabric/](Classic%20Editions/3.%20Fabric/), a Fabric-native thin client.

---

⚠️ Important usage & compliance disclaimer

Please note:

While this tool helps customers better understand their AI usage data, Microsoft has no visibility into the data that customers input into this template/tool, nor does Microsoft have any control over how customers will use this template/tool in their environment.

Customers are solely responsible for ensuring that their use of the template tool complies with all applicable laws and regulations, including those related to data privacy and security.

Microsoft disclaims any and all liability arising from or related to customers' use of the template tool.

Experimental Template Notice: This is an experimental template with audit logs as the primary source. The audit logs from Microsoft Purview are intended to support security and compliance use cases. While they provide visibility into Copilot and Agent interactions, they are not intended to serve as the sole source of truth for licensing or full-fidelity reporting on Copilot or Agent activity. For the most accurate and reliable usage insights, users are encouraged to refer to data from the Microsoft 365 Admin Center and Viva Insights. Currently available in English only.

---

📦 What is PAX?

Show this section (click to expand)

PAX stands for Portable Audit eXporter. It's a free, open-source PowerShell script from the Microsoft Copilot Growth ROI Advisory team that:

• Pulls Microsoft 365 Copilot audit data out of Microsoft Purview
• Pulls user, organization, and licensing data out of Microsoft Entra and the Microsoft 365 Admin Center (MAC)
• Pull additional agent details from Agent 365
• Writes the results as CSV files — locally, to SharePoint, or to OneLake/Fabric
• When run with one of the rollup switches (see below), it also pre-processes the Purview and Entra/MAC CSVs into the exact format this dashboard template expects. The optional Agent 365 data...