Microsoft Power BI MCP
Use Microsoft Power BI with Claude Desktop, Cursor, or Windsurf to let AI read, act, and automate — no code required.
Or build automated Microsoft Power BI workflowsHow to use this MCP
Connect Your Microsoft Power BI Account
Sign up and connect your Microsoft Power BI account to Activepieces.
Start freeGet Your MCP Server URL
Get your MCP URL and install it in Claude Desktop, Cursor, or Windsurf.
Ask AI to Act
Ask your AI assistant to read emails, manage your calendar, and more.
Microsoft Power BI Actions
Create Dataset
Create a new dataset in Power BI with custom schema (Push, Streaming, or PushStreaming mode).
Push Rows to Dataset Table
Add rows to a table in a Power BI dataset (supports Push, Streaming, and PushStreaming modes)
Refresh Dataset
Triggers a refresh of a Power BI dataset so its data reflects the latest changes from the underlying source.
Run DAX Query
Executes a DAX (Data Analysis Expressions) query against a Power BI dataset and returns the resulting rows.
Export Report to File
Exports a Power BI report to a PDF, PPTX, or PNG file.
List Reports
Lists all reports in a Power BI workspace.
Clone Report
Creates a copy of a Power BI report, optionally into a different workspace or bound to a different dataset.
Import File (.pbix)
Uploads a Power BI Desktop (.pbix), Excel (.xlsx), or RDL file into a workspace, creating a new dataset and report.
Custom API Call
Make a custom API call to a specific endpoint
Get started
Start automating in minutes.
Join 300,000+ builders at MoneyGram, Alan, and PostHog shipping secure, open source AI automation.