Available tools
6 tools| Tool | Description |
|---|---|
Workspace, dashboard, report & dataset listing | — |
DAX query execution against datasets | — |
Dataset refresh triggers + history | — |
Push datasets, create + push rows + clear | — |
Dashboards, create + clone tiles | — |
PBIX / PBIT template upload + parameter filling | — |
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 tools appear automatically. Try runDax({ datasetId, query: 'EVALUATE TOPN(10, …)' }) to ask a question, or createPushDataset() + pushRowsToTable() to start building.
Connect to your AI assistant
Pick the tool your team uses for the exact setup steps.
- 1
Open Claude settings
Launch Claude, click the profile button (bottom left), and go to Settings.
- 2
Access connectors
Open the Connectors tab, scroll to the bottom, and click “Add custom connector”.
- 3
Name your connector
Enter any name you’d like for this connector.
- 4
Get the connector URL
Log in to PatchOps, open the /mcp page, and copy the connector URL you want to use.
- 5
Add the connector
Paste the URL into the “Remote MCP server URL” box and click Add.
- 6
Start using
Your Power BI connector is ready to use in Claude.