Edit

Get started with Fabric Core MCP Server

Connect your AI agent to Microsoft Fabric using the cloud-hosted Core MCP Server and start managing workspaces with natural language. This quickstart guides you through setup and your first interaction.

Time to complete: 5-10 minutes

Note

Fabric Core MCP Server is currently in preview. Features and configuration may change before general availability.

Tip

Want to understand the architecture and security model first? See the Fabric Core MCP Server overview. Or compare with Fabric Pro-Dev MCP Server for local development.

Prerequisites

Before you begin, ensure you have:

  • Microsoft Fabric access — An active Fabric tenant with at least one workspace you can access
  • MCP-compatible agent — VS Code with GitHub Copilot (recommended) or Claude Desktop
  • Microsoft Entra ID account — Your Microsoft work or school account with Fabric permissions

Add Fabric Core MCP Server

Select your AI agent to see setup instructions:

Configure VS Code

  1. In VS Code, press Ctrl+Shift+P (or Cmd+Shift+P on macOS) to open the command palette.

  2. Type MCP: Add Server and select HTTP from the list.

  3. Enter the Fabric Core MCP Server URL:

    https://api.fabric.microsoft.com/v1/mcp/core
    
  4. When prompted for a server name, enter fabric.

  5. VS Code opens your browser for authentication. Sign in with your Microsoft Entra ID account.

    The browser window closes automatically after successful authentication.

Alternative: Manual configuration

You can also configure Fabric Core MCP Server by editing your VS Code settings file directly.

Add the following to .vscode/mcp.json:

{
  "servers": {
    "fabric": {
      "type": "http",
      "url": "https://api.fabric.microsoft.com/v1/mcp/core"
    }
  }
}

Verify the connection

After configuring your AI agent, verify that Fabric Core MCP Server is connected:

  1. In VS Code, open GitHub Copilot Chat by pressing Ctrl+Alt+I (or Cmd+Alt+I on macOS).

  2. Enter the following prompt:

    List all my Fabric workspaces
    
  3. Copilot uses Fabric Core MCP Server to retrieve your workspaces.

    You should see a list of workspace names that you have access to.

Tip

If the connection fails, disconnect and reconnect the MCP server in your AI agent settings. Ensure you have at least Viewer access to one Fabric workspace in your tenant.

Try example prompts

Now that you're connected, try these common operations:

Explore resources:

Show me all items in the Sales Analytics workspace
What lakehouses exist in my development environment?

Create resources:

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

Manage permissions:

List all role assignments for the Finance workspace
Add john@contoso.com as a Contributor to my Dev workspace

Optional: Add Microsoft Graph MCP integration

To enable user and group resolution by email address, you can also connect the Microsoft Graph MCP Server. This enhancement allows you to grant access using email addresses instead of looking up user IDs manually.

Why add Graph MCP

Without Graph MCP:

Add user {uuid-guid} as Contributor to Sales Analytics

With Graph MCP:

Add john@contoso.com as Contributor to Sales Analytics

The AI agent automatically resolves email addresses to user principal IDs.

Example commands with Graph MCP

  • "Add the Marketing team to Sales Analytics workspace as Viewers"
  • "Grant john@contoso.com Contributor access to my Dev workspace"
  • "Who are the members of the Finance Admins group?"

Setup Graph MCP

Follow the setup instructions at Get started with Microsoft MCP Server for Enterprise.

Clean up

To remove the Fabric Core MCP Server connection:

  1. Press Ctrl+Shift+P (or Cmd+Shift+P on macOS).
  2. Type MCP: Remove Server and select it.
  3. Select fabric from the list.

Next steps