Hosting

Vendor-hosted remote MCP service

Transport

Streamable HTTP

Endpoint

https://api.fabric.microsoft.com/v1/mcp/powerbi

Authentication

Microsoft sign-in; access is governed by tenant settings, account permissions and client OAuth.

Requirements

• Power BI tenant admin must enable the MCP server preview setting.
• User needs Build permission on at least one semantic model.
• MCP client supporting remote HTTP and Microsoft authentication.

Setup steps

1. Ask the tenant admin to enable “Users can use the Power BI Model Context Protocol server endpoint (preview)”.
2. Add https://api.fabric.microsoft.com/v1/mcp/powerbi as a remote HTTP MCP endpoint.
3. Sign in with Microsoft, provide an authorized semantic model ID, and verify using schema/metadata retrieval before running a data query.

Microsoft names four tools in the setup guide; not confirmed against live tools/list.

• Execute Query

  Run a DAX query against a semantic model.

  01
• Get Semantic Model Schema

  Read semantic model structure.

  02
• Get Report Metadata

  Read report metadata.

  03
• Generate Query

  Generate a query for a semantic model.

  04

This server’s available tools can vary by account, permissions, or configuration. The list shown is not its full runtime catalog.

• Preview endpoint.
• Tenant admin must enable it, and user needs Build permission.
• Microsoft recommends Fabric IQ MCP as the primary semantic-model consumption server.

• official vendor setup

  Microsoft documents the hosted endpoint, preview status, admin prerequisite, Build permission, setup and four tools.

• official tool documentation

  Microsoft remote MCP documentation lists exactly four tools: Execute Query, Get Semantic Model Schema, Get Report Metadata, and Generate Query.

Documentation checked 2026-10-28T00:00:00Z. Connection has not been runtime tested.