How to Connect Power BI to MCP for AI Agents

Power BI Analytics with AI Agents

Microsoft Power BI is the leading business intelligence platform. Connecting Power BI to MCP enables AI agents to query datasets, access report data, and trigger data refreshes.

Step-by-Step Guide

Step 1: Deploy AnythingMCP

curl -fsSL https://raw.githubusercontent.com/HelpCode-ai/anythingmcp/main/docker-compose.quickstart.yml -o docker-compose.yml
printf 'JWT_SECRET=%s\nENCRYPTION_KEY=%s\n' "$(openssl rand -hex 32)" "$(openssl rand -hex 32)" > .env
docker compose up -d

Step 2: Create a REST Connector

Open the AnythingMCP dashboard at http://localhost:3000 and create a new REST connector. Set the base URL to the Power BI REST API endpoint (https://api.powerbi.com/v1.0/myorg).

Step 3: Configure Authentication

In the connector settings, configure OAuth 2.0 with your Azure AD App Registration credentials, using the Power BI Service API permissions.

Step 4: Import and Customize Tools

Configure endpoints for datasets, reports, dashboards, and data refresh operations in the dashboard.

Step 5: Test and Connect

{
  "mcpServers": {
    "powerbi": {
      "url": "http://localhost:4000/mcp"
    }
  }
}

AI Agent Use Cases

• "Show me the sales dashboard data for this quarter"
• "Refresh the marketing dataset"
• "What reports are available in the Finance workspace?"
• "Query the revenue dataset for last month's totals"

Best Practices

1. Azure AD app — Register with Power BI API permissions
2. Service principal — Use a service principal for production access
3. DAX queries — Use DAX query endpoints for custom data retrieval
4. Capacity management — Be mindful of Power BI capacity when querying

Next Steps

• Dynamics 365 to MCP Guide — Microsoft ERP/CRM
• REST to MCP Guide — General REST patterns