How microsoft/ai-in-one-dashboard works
AI-in-One Dashboard is a Power BI product for analyzing Microsoft Copilot and Agent adoption. The main workflow is to export Purview interaction and Entra/Microsoft 365 licensing and organization data, preprocess it into rollup files, then load those files into a Power BI template for analysis. The README also documents Agent 365 data, local/SharePoint/OneLake input options, a SharePoint-only scheduled-refresh edition, and a Fabric edition. Processor behavior is supported by the sampled Python excerpt; template internals and Fabric wiring were not sampled, so those links are limited to documented behavior.
Main entry points: AIO Dashboard - Rollup Edition - 2026-06-25.pbit Rollup template · Rollup_Processor_v3.0.0.py Rollup processor · AIO Dashboard - Rollup Edition - PBI-SharePoint - 2026-06-25.pbit SharePoint template · AI-in-One Dashboard - Fabric.pbit Fabric template
Components 16
Data collection
- Purview audit
- Entra and MAC
- Agent 365
- PAX exporter
- Raw CSV files
Rollup processing
- Rollup processor
scripts/Rollup_Processor_v3.0.0.py - Rollup CSV files
Power BI reporting
- Rollup template
AIO Dashboard - Rollup Edition - 2026-06-25.pbit
Deployment editions
- SharePoint template
AIO Dashboard - Rollup Edition - PBI-SharePoint - 2026-06-25.pbit - Fabric template
Classic Editions/3. Fabric/AI-in-One Dashboard - Fabric.pbit - SharePoint files
- OneLake files
- Power BI Service
- Fabric ingestion
Classic Editions/3. Fabric/notebooks - Fabric pipeline
Classic Editions/3. Fabric/pipelines/CopilotAdoptionPipeline.DataPipeline/pipeline-content.json
Other components
- AI leader
Connections 16
- AI leader → Rollup template: opens and configures
- Purview audit → PAX exporter: exports audit data
- Entra and MAC → PAX exporter: exports user data
- Agent 365 → PAX exporter: exports agent data
- PAX exporter → Raw CSV files: writes CSV
- Raw CSV files → Rollup processor: supplies two inputs
- Rollup processor → Rollup CSV files: writes fact and user files
- PAX exporter → Rollup CSV files: can preprocess
- Rollup CSV files → Rollup template: loads files
- Rollup template → SharePoint files: reads optional files
- Rollup template → OneLake files: reads optional files
- SharePoint template → SharePoint files: reads static sources
- Power BI Service → SharePoint template: schedules refresh
- Fabric ingestion → Fabric pipeline: orchestrated by
- Fabric template → OneLake files: uses Fabric data
- AI leader → Power BI Service: publishes report