Edit

Get started with Fabric Core MCP Server

Connect your AI agent to the remote Fabric Core MCP Server, and then use natural language to manage Fabric workspaces and items.

Time to complete: 5–10 minutes

Prerequisites

Before you begin, make sure you have:

  • Microsoft Fabric access — A work or school account in Microsoft Entra ID that can access at least one Fabric workspace
  • MCP client — An MCP host, or your own agent, that supports Streamable HTTP transport and Microsoft Entra ID sign-in (VS Code with GitHub Copilot is recommended)

Add Fabric Core MCP Server

Select how you connect: VS Code with GitHub Copilot, another MCP host, or your own agent.

Select Install Fabric Core MCP Server in VS Code. VS Code adds the server with the name fabric. When the server starts, sign in with your Microsoft Entra ID account.

Add the server yourself

Add the following to .vscode/mcp.json, and then start the fabric server and sign in with your Microsoft Entra ID account:

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

For other ways to add, start, and manage servers, see Use MCP servers in VS Code.

Verify the connection

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

In GitHub Copilot Chat, enter the following prompt:

List all my Fabric workspaces

Copilot uses Fabric Core MCP Server and lists the workspaces that you can access.

Try example prompts

Important

Some examples create resources or change access permissions. Review the proposed tool calls and your client's approval settings before you allow changes. For more guidance, see Security and compliance.

Explore resources:

Show me all items in the Sales Analytics workspace
Show the OneLake data access roles for the Sales lakehouse. Don't change any roles.

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

Tip

To grant access by email address, as in the last example, also connect Microsoft MCP Server for Enterprise. Without it, provide the user's object ID.

Troubleshoot

In VS Code or another MCP host

Problem Solution
You aren't asked to sign in, or sign-in fails. Make sure that your MCP host supports Microsoft Entra ID sign-in, and sign in with your work or school account. In VS Code, remove the fabric server and add it again.
Sign-in asks for admin approval. Your organization requires an admin to approve the app that you sign in with. Ask your admin to approve it. The app's name appears on the sign-in screen.
The agent reports an invalid workspace ID. Ask the agent to list your workspaces, and then refer to the workspace by its ID.
The agent can't find a workspace or item that you expect. Check the name or ID, and check that you can access the workspace or item in Fabric.
A tool that you expect isn't available. Tools can change over time. Refresh the server's tool list in your MCP host, or see the tools reference.

In your own agent

When a tool call fails, the error usually appears in the tool result, with isError set to true, rather than as an HTTP error. The result includes an error code and message.

Error Cause and solution
401 with "errorCode": "TokenIsMissing" and "Access token is required" The request didn't include an access token. Send the token in an Authorization: Bearer header.
401 with JSON-RPC error -32600 and "Unable to process the request" The token isn't valid. Acquire a new token for https://api.fabric.microsoft.com.
"Invalid arguments for tool <name>" Check the arguments against the tool's input schema in the tools/list response.
"errorCode": "WorkspaceNotFound" or "EntityNotFound" The workspace or item wasn't found. Check that the ID is correct.
JSON-RPC error -32602 and "Tool <name> not found" The tool name is wrong or no longer exists. List the server's tools again.

If you contact Microsoft support, include the time of the error, the MCP client that you use, and the request ID if the error shows one.

Clean up

To remove the Fabric Core MCP Server connection:

Remove the fabric server from your VS Code MCP configuration. For details, see Use MCP servers in VS Code.

Next steps