What you can ask
- “What does Power BI have for the area or asset I'm working on?”
- “Pull the most recent Power BI records and put them in a table.”
- “What does Power BI cover, and how fresh is the data?”
Connect to your AI assistant
Paste this URL into Claude, ChatGPT, or any MCP client, then sign in when prompted. After you sign in, add your Power BI key in PatchOps.
https://patchops.ai/api/mcpClaude: use Add to Claude, or Settings > Connectors > Add custom connector and paste the URL.
Claude Code
claude mcp add --transport http patchops https://patchops.ai/api/mcpStep by step
- 1
Open connectors
In Claude, open Settings > Connectors and click "Add custom connector".
- 2
Paste the URL
Name it PatchOps and paste
https://patchops.ai/api/mcpas the server URL, then click Add. - 3
Sign in
Click Connect and sign in to PatchOps when Claude asks.
- 4
Start using
Ask Claude a question. It uses Power BI through PatchOps when it needs to.
› Technical details
Microsoft Power BI REST API with exact operations for datasets, reports, dashboards, workspaces, gateways, pipelines, imports, and administration.
Setup
A few steps to connect your AI agents to Power BI.
- 1
Authorize Power BI
Connect your Microsoft account to PatchOps and grant the Power BI scopes.
- 2
Grant permissions
Approve Workspace.ReadWrite.All, Dashboard.ReadWrite.All, Report.ReadWrite.All, Dataset.ReadWrite.All, and Content.Create on the Microsoft consent screen.
- 3
Use in PatchOps MCP
Power BI operations appear automatically. Search for the dataset, report, dashboard, gateway, pipeline, import, or administration operation you need.
