Skip to content
Microsoft Power BI logo

Microsoft Power BI MCP server

Create and manage Power BI datasets and reports, and push data to them

Microsoft Power BI is not a separate install. One Activepieces MCP server exposes it alongside 760+ other apps, behind a single URL.

Tools
9
Works with
Any MCP client
Auth
OAuth 2.0
License
MIT, open source
Updated
October 2026

About the Microsoft Power BI MCP server

Connect Microsoft Power BI once in Activepieces and every action it ships becomes a tool your assistant can call, behind the same server URL as the rest of your apps. Your agent reaches Microsoft Power BI and 760+ other apps over a single connection, on our cloud or a self-hosted install.

Tools

Microsoft Power BI tools your AI can run

Once connected, your assistant can call any of these Microsoft Power BI actions by asking in plain language.

  • Create Dataset

    Create a new dataset in Power BI with custom schema (Push, Streaming, or PushStreaming mode).

    3 fields

  • Push Rows to Dataset Table

    Add rows to a table in a Power BI dataset (supports Push, Streaming, and PushStreaming modes)

    4 fields

  • Refresh Dataset

    Triggers a refresh of a Power BI dataset so its data reflects the latest changes from the underlying source.

    3 fields

  • Run DAX Query

    Executes a DAX (Data Analysis Expressions) query against a Power BI dataset and returns the resulting rows.

    5 fields

  • Export Report to File

    Exports a Power BI report to a PDF, PPTX, or PNG file.

    4 fields

  • List Reports

    Lists all reports in a Power BI workspace.

    1 field

  • Clone Report

    Creates a copy of a Power BI report, optionally into a different workspace or bound to a different dataset.

    5 fields

  • Import File (.pbix)

    Uploads a Power BI Desktop (.pbix), Excel (.xlsx), or RDL file into a workspace, creating a new dataset and report.

    6 fields

  • Custom API Call

    Make a custom API call to a specific endpoint

    10 fields

Give your assistant Microsoft Power BI

Connect Microsoft Power BI once and every tool above is callable from Claude, Cursor or any MCP client, behind the same server URL as 760+ other apps. Free to start.

Microsoft Power BI MCP, answered.

No. That is the point of it. One Activepieces server exposes Microsoft Power BI alongside every other piece you connect, so your client keeps a single connection.

Yes. Activepieces is open source and free to start, and the MCP server is included on every plan, from the free cloud tier to any self-hosted deployment.

Connect Microsoft Power BI in Activepieces, enable the server under Settings → MCP Server, then paste your server URL into your client config. It authenticates over OAuth on first use.

It can call 9 tools, including Create Dataset, Push Rows to Dataset Table, Refresh Dataset, and chain them with steps in other apps inside the same run.

Connections use OAuth2 with limited scopes and are stored under 256-bit encryption, with no API to read them back, so an agent gets scoped access rather than your keys.