AI agent for Power BI
Connect Power BI to your AI agent through the WorkAist MCP server.
The WorkAist Power BI connector is a production-grade Model Context Protocol (MCP) server. AI agents can read and write Power BI data — analytics — through one consistent interface. Open-source under AGPL-3.0, self-hosted, with reversible PII redaction at the LLM boundary.
Authentication & setup
The Power BI connector authenticates via Microsoft OAuth 2.0.
WorkAist redirects you to the provider, you authorize, and the access token is encrypted and stored. No keys to copy.
Frequently paired with Power BI
FAQ
Can a WorkAist AI agent really automate Power BI end-to-end?▼
Yes. The connector exposes read and write tools through Model Context Protocol. AI agents call them through plain-language instructions in a CLAUDE.md file — no glue code.
How does this differ from using the Power BI API directly?▼
The connector adds permission isolation, audit logging, cost tracking per agent, and reversible PII redaction at the LLM boundary. It also presents Power BI as part of a unified Knowledge Graph alongside your other tools.
What does it cost?▼
WorkAist is open-source under AGPL-3.0 and self-hosted, so the connector itself is free. You pay only for Power BI's own API costs (if any) and the LLM tokens your agent consumes.
Is my Power BI data sent to a third party?▼
No. WorkAist runs in your own infrastructure. Data flows from Power BI → your WorkAist instance → the LLM you choose. Sensitive fields can be tokenized before reaching the LLM.
What if Power BI changes its API?▼
The connector is versioned and published openly. When Power BI ships breaking changes, we bump the connector version and the marketplace UI surfaces the upgrade as a one-click apply.