Edit

Fabric Core MCP Server tools reference

Fabric Core MCP Server provides tools that AI agents use to interact with Microsoft Fabric. Each tool maps to a Fabric REST API operation and includes input validation and error handling.

Note

Fabric Core MCP Server is currently in preview. Available tools and their capabilities may change before general availability.

Available tools

Tool Description
list_workspaces List all workspaces you have access to
get_workspace Get detailed information about a specific workspace
create_workspace Create a new workspace in your Fabric tenant
update_workspace Update a workspace's name or description
delete_workspace Delete an existing workspace
add_workspace_role Grant a user access to a workspace
list_workspace_roles List all role assignments for a workspace
get_workspace_role Get details about a specific role assignment
update_workspace_role Change a user's role in a workspace
delete_workspace_role Remove a user's access to a workspace
list_items List all items in a workspace
get_item Get detailed information about a specific item
create_item Create a new item in a workspace
update_item Update an item's name or description
delete_item Delete an item from a workspace
get_item_definition Get the schema or definition of an item
update_item_definition Update an item's definition or schema
bulk_move_items Move multiple items to a folder
create_folder Create a new folder in a workspace
list_folders List all folders in a workspace
get_folder Get details about a specific folder
update_folder Rename a folder
delete_folder Delete an empty folder
move_folder Move a folder to a new parent folder
list_capacities List all Fabric capacities you have access to
get_operation_state Check the status of a long-running operation
get_operation_result Get the result of a completed operation
get_knowledge Get guidelines and best practices for item types

Workspace roles

Fabric workspaces support four role levels:

Role Permissions
Admin Full control including workspace settings, role assignments, and deletion
Member Create, edit, and delete items; cannot manage workspace settings or roles
Contributor Create and edit items; cannot delete items
Viewer Read-only access to workspace and items

Important notes

  • You must have permissions to create workspaces in your Fabric tenant. Some organizations restrict workspace creation to specific roles.
  • Deleting a workspace permanently removes all items within it. This operation cannot be undone.
  • Folders must be empty before deletion. Move or delete all items within the folder first.
  • Add Microsoft Graph MCP Server to resolve email addresses automatically. Without it, you need to provide user principal IDs for role operations.

Example workflows

Workflow 1: Explore your environment

Discover what resources you have access to in Fabric.

Prompts:

  1. "List all my Fabric workspaces"
  2. "Show me all items in the Sales Analytics workspace"
  3. "What lakehouses exist in Sales Analytics?"
  4. "Get the definition of the CustomerData lakehouse"

Workflow 2: Create a development environment

Set up a complete development workspace with resources and team access.

Prompts:

  1. "Create a workspace called Sales Analytics Dev"
  2. "Create a lakehouse named CustomerData_Dev in Sales Analytics Dev"
  3. "Add john@contoso.com as a Contributor to Sales Analytics Dev"
  4. "Add sarah@contoso.com as a Member to Sales Analytics Dev"

Tip

This workflow requires Microsoft Graph MCP to resolve email addresses. Without Graph MCP, provide user principal IDs instead of emails.

Workflow 3: Audit and manage permissions

Review and update workspace access control.

Prompts:

  1. "List all role assignments for the Finance workspace"
  2. "Who has Admin access to Finance?"
  3. "Change john@contoso.com from Viewer to Contributor in Finance"
  4. "Remove contractor@contoso.com from the Finance workspace"

Troubleshooting

Invalid workspace ID error

Problem: Error message states "Invalid workspace ID" when you provide a workspace name or ID.

Solution:

  1. Run list_workspaces to get the correct workspace ID.
  2. Use the workspace ID (UUID format) in subsequent operations.

Authentication failed (401 or 403 errors)

Problem: Operations fail with authorization errors.

Solution for VS Code:

  1. Press Ctrl+Shift+P and select MCP: Remove Server, choose fabric.
  2. Press Ctrl+Shift+P and select MCP: Add Server > HTTP.
  3. Enter https://api.fabric.microsoft.com/v1/mcp/core and complete browser authentication.

Solution for Claude Desktop and other clients:

  1. Generate a new access token:

    az account get-access-token --resource https://api.fabric.microsoft.com

  2. Update your client configuration with the new token.

Long-running operation timeout

Problem: Operation appears to timeout or doesn't complete.

Solution: Use the operations tools to monitor async operations:

  1. Note the operation-id returned from the initial operation.
  2. Check status: "Check the status of operation {operation-id}"
  3. Once status is "Succeeded", get the result: "Get the result of operation {operation-id}"

Connection details

  • Endpoint: https://api.fabric.microsoft.com/v1/mcp/core
  • Auth: OAuth 2.0 via Microsoft Entra ID
  • Scope: https://api.fabric.microsoft.com/.default

Related content

  • Last updated on