Fabric Core MCP Server overview

Fabric Core MCP Server is a cloud-hosted endpoint that enables AI agents to interact with Microsoft Fabric using natural language. Built on the Model Context Protocol (MCP), it translates your prompts into Fabric API calls while respecting your permissions and security policies.

How it works

When you connect your AI agent to Fabric Core MCP Server:

1. The agent connects to the cloud endpoint at https://api.fabric.microsoft.com/v1/mcp/core.
2. You authenticate through a browser-based OAuth 2.0 flow with Microsoft Entra ID.
3. The agent discovers available tools (workspaces, items, permissions, folders, capacities).
4. When you ask a question, the agent selects the right tool and the server calls the Fabric REST API on your behalf.
5. All operations respect your Fabric RBAC permissions and are recorded in audit logs.

Supported operations

Fabric Core MCP Server currently supports:

• Workspace operations — List, create, update, and delete workspaces
• Item management — Create, read, update, and delete Fabric items (lakehouses, semantic models, notebooks, pipelines, and 20+ other types)
• Permission management — Grant and revoke workspace roles (Admin, Member, Contributor, Viewer)
• Folder organization — Create and manage folders within workspaces
• Capacity information — List available capacities and check operation status

For the complete list of tools, see the tools reference.

Usage scenarios

Explore your Fabric environment

• "List all my Fabric workspaces"
• "Show me all semantic models in the Sales Analytics workspace"
• "What lakehouses exist in my development environment?"

Create and manage resources

• "Create a workspace called Sales Analytics Dev"
• "Create a lakehouse named CustomerData in the Dev workspace"

Manage permissions

• "Who has Admin access to Sales Analytics?"
• "Add john@contoso.com as a Contributor to my Dev workspace"

Automate workflows

• "Create a new workspace with a lakehouse, then add my team as Contributors"
• "Find all workspaces where I'm an Admin and list their capacity assignments"

Limitations

• All operations respect your existing Fabric permissions (RBAC)
• Some advanced Fabric features may not have corresponding MCP tools yet
• Operations that modify data within items (such as lakehouse tables or notebook code) require direct Fabric access

Next step

Related content

• Fabric MCP Servers overview — Compare Core vs. Pro-Dev servers
• Core MCP tools reference — Complete tools list
• Model Context Protocol specification
• Microsoft Graph MCP Server