Skip to main content
Feedback

Microsoft Power BI MCP connector

Microsoft Power BI is a business analytics platform that transforms raw data into interactive visualizations and insights. The Microsoft Power BI MCP connector allows AI agents to refresh datasets to ensure reports and dashboards reflect the latest data. It supports maintaining up-to-date analytics environments by triggering data refreshes across your Power BI workspaces.

Authentication type

  • OAuth 2.0 Authorization Code - Requires a one-time user login to authorize the agent to access the service on their behalf.

Uses

Use the Microsoft Power BI MCP connector to perform the following actions:

  • Refresh Power BI datasets automatically when upstream data changes in your source systems
  • Trigger on-demand dataset refreshes to ensure dashboards display the latest business metrics
  • Automate Power BI refresh cycles based on scheduled workflows or real-time events
  • Reduce manual refresh delays and ensure stakeholders access current analytics without waiting
  • Integrate Power BI dataset refreshes into multi-step workflows that span CRM, ERP, and data warehouses
  • Monitor data freshness by triggering refreshes after critical business transactions complete
  • Eliminate data staleness in executive dashboards by refreshing datasets on a defined schedule

Example prompts

Use the following example prompts to invoke Microsoft Power BI MCP connector tools from your AI assistant or Boomi Connect workflow:

  • Refresh the sales performance dataset in Microsoft Power BI.
  • Trigger a refresh for the customer analytics dataset in Microsoft Power BI after new records load.
  • Automatically refresh my Microsoft Power BI revenue dashboard every morning at 6 AM.
  • Run a refresh on the Microsoft Power BI dataset that powers our financial statements.
  • Refresh the Microsoft Power BI dataset whenever new data arrives from our data warehouse.
  • Trigger a refresh for the Microsoft Power BI dataset supporting our executive KPI reports.
  • Refresh all datasets in Microsoft Power BI related to quarterly sales performance.
  • Automatically refresh the Microsoft Power BI dataset after our marketing campaign data syncs.
  • Trigger an immediate refresh of the Microsoft Power BI dataset for real-time reporting.
  • Refresh the Microsoft Power BI dataset that tracks inventory and supply chain metrics.

Microsoft Power BI MCP connector tools

The Microsoft Power BI MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

ToolDescription
microsoftpowerbi_microsoftpowerbirefreshdataset_invokeInitiates an update of data in a Power BI dataset to reflect the latest information.
On this Page