Skip to main content
Feedback

Microsoft Power BI MCP connector

Updated 

Microsoft Power BI is Microsoft's business analytics platform for turning raw data into interactive reports and dashboards. The Microsoft Power BI MCP connector allows AI agents to refresh datasets so reports reflect the latest available data. It supports keeping analytics workflows current without manual intervention, ensuring stakeholders always view up-to-date insights.

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:

  • Trigger a Power BI dataset refresh after new data loads
  • Keep dashboards current without manual intervention in Power BI
  • Sync scheduled workflows to refresh reports before meetings
  • Automate refreshes tied to upstream data pipeline completions
  • Ensure stakeholders view up-to-date metrics in Power BI reports
  • Reduce manual refresh clicks across multiple Power BI datasets
  • Trigger refreshes on demand when source systems update
  • Align report data with the latest business transactions

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 dataset in Microsoft Power BI now.
  • Update my quarterly revenue report in Microsoft Power BI.
  • Trigger a data refresh for the finance dashboard in Power BI.
  • Make sure the inventory dataset in Power BI has the latest numbers.
  • Refresh the customer analytics dataset in Microsoft Power BI.
  • Update the marketing performance report in Power BI before the meeting.
  • Kick off a refresh for the HR dashboard in Microsoft Power BI.
  • Sync the latest transactions into the Power BI sales dataset.
  • Refresh the operations dataset in Microsoft Power BI immediately.
  • Update the executive summary dashboard with the newest data in Power BI.

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_invokeTrigger a refresh for the specified Power BI dataset
On this Page