# microsoft/ai-in-one-dashboard architecture

> Architecture diagram of the GitHub repository microsoft/ai-in-one-dashboard, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-28). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/microsoft/ai-in-one-dashboard
- Repository: https://github.com/microsoft/ai-in-one-dashboard

## Overview

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`](https://github.com/microsoft/ai-in-one-dashboard/blob/main/AIO%20Dashboard%20-%20Rollup%20Edition%20-%202026-06-25.pbit) (Rollup template), [`scripts/Rollup_Processor_v3.0.0.py`](https://github.com/microsoft/ai-in-one-dashboard/blob/main/scripts/Rollup_Processor_v3.0.0.py) (Rollup processor), [`AIO Dashboard - Rollup Edition - PBI-SharePoint - 2026-06-25.pbit`](https://github.com/microsoft/ai-in-one-dashboard/blob/main/AIO%20Dashboard%20-%20Rollup%20Edition%20-%20PBI-SharePoint%20-%202026-06-25.pbit) (SharePoint template), [`Classic Editions/3. Fabric/AI-in-One Dashboard - Fabric.pbit`](https://github.com/microsoft/ai-in-one-dashboard/blob/main/Classic%20Editions/3.%20Fabric/AI-in-One%20Dashboard%20-%20Fabric.pbit) (Fabric template)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_collection["Data collection"]
  node_purview["Purview audit"]
  node_entra["Entra and MAC"]
  node_agent365["Agent 365"]
  node_pax["PAX exporter"]
  node_rawcsv["Raw CSV files"]
end

subgraph group_processing["Rollup processing"]
  node_processor["Rollup processor"]
  node_rollupcsv["Rollup CSV files"]
end

subgraph group_reporting["Power BI reporting"]
  node_rolluptemplate["Rollup template"]
end

subgraph group_deployment["Deployment editions"]
  node_sp_template["SharePoint template"]
  node_fabric_template["Fabric template"]
  node_sharepoint["SharePoint files"]
  node_onelake["OneLake files"]
  node_powerbi["Power BI Service"]
  node_fabric_ingest["Fabric ingestion<br/>[notebooks]"]
  node_fabric_pipeline["Fabric pipeline"]
end

node_analyst(("AI leader"))

node_analyst -->|"opens and configures"| node_rolluptemplate
node_purview -.->|"exports audit data"| node_pax
node_entra -.->|"exports user data"| node_pax
node_agent365 -.->|"exports agent data"| node_pax
node_pax -.->|"writes CSV"| node_rawcsv
node_rawcsv -->|"supplies two inputs"| node_processor
node_processor -->|"writes fact and user files"| node_rollupcsv
node_pax -.->|"can preprocess"| node_rollupcsv
node_rollupcsv -->|"loads files"| node_rolluptemplate
node_rolluptemplate -.->|"reads optional files"| node_sharepoint
node_rolluptemplate -.->|"reads optional files"| node_onelake
node_sp_template -->|"reads static sources"| node_sharepoint
node_powerbi -->|"schedules refresh"| node_sp_template
node_fabric_ingest -.->|"orchestrated by"| node_fabric_pipeline
node_fabric_template -.->|"uses Fabric data"| node_onelake
node_analyst -->|"publishes report"| node_powerbi

click node_processor "https://github.com/microsoft/ai-in-one-dashboard/blob/main/scripts/Rollup_Processor_v3.0.0.py"
click node_rolluptemplate "https://github.com/microsoft/ai-in-one-dashboard/blob/main/AIO%20Dashboard%20-%20Rollup%20Edition%20-%202026-06-25.pbit"
click node_sp_template "https://github.com/microsoft/ai-in-one-dashboard/blob/main/AIO%20Dashboard%20-%20Rollup%20Edition%20-%20PBI-SharePoint%20-%202026-06-25.pbit"
click node_fabric_template "https://github.com/microsoft/ai-in-one-dashboard/blob/main/Classic%20Editions/3.%20Fabric/AI-in-One%20Dashboard%20-%20Fabric.pbit"
click node_fabric_ingest "https://github.com/microsoft/ai-in-one-dashboard/tree/main/Classic%20Editions/3.%20Fabric/notebooks"
click node_fabric_pipeline "https://github.com/microsoft/ai-in-one-dashboard/blob/main/Classic%20Editions/3.%20Fabric/pipelines/CopilotAdoptionPipeline.DataPipeline/pipeline-content.json"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_purview,node_entra,node_agent365,node_pax,node_rawcsv toneBlue
class node_processor,node_rollupcsv toneAmber
class node_rolluptemplate toneMint
class node_sp_template,node_fabric_template,node_sharepoint,node_onelake,node_powerbi,node_fabric_ingest,node_fabric_pipeline toneRose
class node_analyst toneIndigo
```

## Components

### Data collection

- **Purview audit**
- **Entra and MAC**
- **Agent 365**
- **PAX exporter**
- **Raw CSV files**

### Rollup processing

- [Rollup processor](https://github.com/microsoft/ai-in-one-dashboard/blob/main/scripts/Rollup_Processor_v3.0.0.py): `scripts/Rollup_Processor_v3.0.0.py`
- **Rollup CSV files**

### Power BI reporting

- [Rollup template](https://github.com/microsoft/ai-in-one-dashboard/blob/main/AIO%20Dashboard%20-%20Rollup%20Edition%20-%202026-06-25.pbit): `AIO Dashboard - Rollup Edition - 2026-06-25.pbit`

### Deployment editions

- [SharePoint template](https://github.com/microsoft/ai-in-one-dashboard/blob/main/AIO%20Dashboard%20-%20Rollup%20Edition%20-%20PBI-SharePoint%20-%202026-06-25.pbit): `AIO Dashboard - Rollup Edition - PBI-SharePoint - 2026-06-25.pbit`
- [Fabric template](https://github.com/microsoft/ai-in-one-dashboard/blob/main/Classic%20Editions/3.%20Fabric/AI-in-One%20Dashboard%20-%20Fabric.pbit): `Classic Editions/3. Fabric/AI-in-One Dashboard - Fabric.pbit`
- **SharePoint files**
- **OneLake files**
- **Power BI Service**
- [Fabric ingestion](https://github.com/microsoft/ai-in-one-dashboard/tree/main/Classic%20Editions/3.%20Fabric/notebooks): `Classic Editions/3. Fabric/notebooks`
- [Fabric pipeline](https://github.com/microsoft/ai-in-one-dashboard/blob/main/Classic%20Editions/3.%20Fabric/pipelines/CopilotAdoptionPipeline.DataPipeline/pipeline-content.json): `Classic Editions/3. Fabric/pipelines/CopilotAdoptionPipeline.DataPipeline/pipeline-content.json`

### Other components

- **AI leader**

## Connections

- 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