Turn your Microsoft 365 Copilot audit data into actionable Power BI dashboards — no scripting required.
PAX Cookbook is a Windows desktop app that collects Microsoft 365 Copilot adoption and usage data from your organization's Microsoft Purview audit logs and prepares it for Power BI dashboards — all through a friendly, guided experience.
It's built for the people who need to measure Copilot's impact: analysts, IT admins, project managers, and business leaders tracking adoption and return on investment. You don't write any code. You make a few choices in a step-by-step builder, and PAX Cookbook does the rest.
Under the hood, PAX Cookbook drives an open-source engine called PAX (the Purview Audit Log Processor) — the tool that knows how to pull the right records from Microsoft 365 and shape them into clean output. PAX Cookbook gives you all of that power without the command line, and every run produces structured data that's ready for Power BI (or any reporting tool).
- 📈 Track daily Copilot adoption — feed the AI-in-One dashboard with a fresh pull every day, automatically.
- 💰 Measure Copilot ROI — feed the AI Business Value dashboard with business-impact metrics.
- 📊 Analyze broader M365 usage — feed the M365 Usage Analytics dashboard beyond just Copilot.
- 👥 Export your user directory — pull Microsoft Entra user details to enrich your reports.
- 🧩 Build custom collections — configure exactly what you need for any reporting system.
PAX Cookbook's output feeds the team's ready-made Power BI dashboard templates:
- AI-in-One — a comprehensive Copilot adoption view
- AI Business Value — ROI and business-impact metrics
- M365 Usage Analytics — broader Microsoft 365 usage
The output is structured and standard, so it also works with any reporting tool that can read data files — not just Power BI.
📸 Screenshot: A Power BI dashboard populated with PAX Cookbook data (or the PAX Cookbook home page if a dashboard image isn't available).
- Download
PAX_Cookbook_Setup.exefrom the latest Release. - Double-click it. The wizard installs the components it needs (.NET 8, PowerShell 7, Python) for you.
- Open PAX Cookbook from the Start Menu.
- Go to Recipes → New Recipe. Pick a name and the AI-in-One preset, choose Device Code sign-in and Previous Day, pick a local output folder, and Save.
- Open the recipe and click Bake. Confirm with Windows Hello and watch it collect your data.
- Open the output folder — your data is ready for Power BI.
That's it. For the full walkthrough, see the User Guide.
📸 Screenshot: The Setup wizard Welcome screen.
📸 Screenshot: The recipe builder with the AI-in-One preset selected.
📸 Screenshot: A completed bake showing its output files.
- 📖 Full User Guide — complete, step-by-step instructions for every feature.
- ⚙️ PAX engine — the open-source tool that powers data collection.
- Download
PAX_Cookbook_Setup.exefrom the latest Release. - Double-click to run the wizard. It checks for and installs the prerequisites (.NET 8, PowerShell 7, Python) automatically.
- Follow the prompts to finish, then launch from the Start Menu.
The installer isn't code-signed yet, so Windows SmartScreen may show "Windows protected your PC." Click More info → Run anyway to continue.
For detailed installation help — including system requirements, uninstalling, and updating — see the User Guide.
For contributors and developers
Prerequisites
- .NET 8 SDK
- Node.js 18+
Build the app
# Build the .NET solution
dotnet build PAXCookbook.sln -c Release
# Build the web UI
cd app/web-react
npm ci
npm run buildBuild the installer
pwsh -File tools/release/Build-Setup.ps1This produces the distributable PAX_Cookbook_Setup.exe and PAX_Cookbook_Payload.zip under dist/setup/.
PAX Cookbook is licensed under the MIT License. See LICENSE for details.
- 🌐 Website: https://PAXcookbook.com
- ⚙️ PAX engine: https://github.com/microsoft/PAX
- 🐛 Report issues: https://github.com/microsoft/PAX-Cookbook/issues