Microsoft Fabric MCP Server

Name: Microsoft Fabric MCP Server
Author: snahrup

snahrup

Model Context Protocol (MCP) server for Microsoft Fabric & Power BI - Query datasets, execute DAX, refresh data, and manage workspaces

Setup

Choose your client, copy the config, then fill in any required environment variables.

Add to Cursor Add to VS Code

claude mcp add microsoft-fabric-server-snahrup --env AZURE_TENANT_ID='<AZURE_TENANT_ID>' --env AZURE_CLIENT_ID='<AZURE_CLIENT_ID>' --env AZURE_CLIENT_SECRET='<AZURE_CLIENT_SECRET>' -- npx -y @strainprint/microsoft-fabric-mcp

~/.codex/config.toml

[mcp_servers.microsoft-fabric-server-snahrup]
command = "npx"
args = ["-y", "@strainprint/microsoft-fabric-mcp"]
env = { AZURE_TENANT_ID = "<AZURE_TENANT_ID>", AZURE_CLIENT_ID = "<AZURE_CLIENT_ID>", AZURE_CLIENT_SECRET = "<AZURE_CLIENT_SECRET>" }

# codex mcp add microsoft-fabric-server-snahrup --env AZURE_TENANT_ID='<AZURE_TENANT_ID>' --env AZURE_CLIENT_ID='<AZURE_CLIENT_ID>' --env AZURE_CLIENT_SECRET='<AZURE_CLIENT_SECRET>' -- npx -y @strainprint/microsoft-fabric-mcp

~/.cursor/mcp.json

{
  "mcpServers": {
    "microsoft-fabric-server-snahrup": {
      "command": "npx",
      "args": [
        "-y",
        "@strainprint/microsoft-fabric-mcp"
      ],
      "env": {
        "AZURE_TENANT_ID": "<AZURE_TENANT_ID>",
        "AZURE_CLIENT_ID": "<AZURE_CLIENT_ID>",
        "AZURE_CLIENT_SECRET": "<AZURE_CLIENT_SECRET>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "microsoft-fabric-server-snahrup": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@strainprint/microsoft-fabric-mcp"
      ],
      "env": {
        "AZURE_TENANT_ID": "<AZURE_TENANT_ID>",
        "AZURE_CLIENT_ID": "<AZURE_CLIENT_ID>",
        "AZURE_CLIENT_SECRET": "<AZURE_CLIENT_SECRET>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "microsoft-fabric-server-snahrup": {
      "command": "npx",
      "args": [
        "-y",
        "@strainprint/microsoft-fabric-mcp"
      ],
      "env": {
        "AZURE_TENANT_ID": "<AZURE_TENANT_ID>",
        "AZURE_CLIENT_ID": "<AZURE_CLIENT_ID>",
        "AZURE_CLIENT_SECRET": "<AZURE_CLIENT_SECRET>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "microsoft-fabric-server-snahrup": {
      "command": "npx",
      "args": [
        "-y",
        "@strainprint/microsoft-fabric-mcp"
      ],
      "env": {
        "AZURE_TENANT_ID": "<AZURE_TENANT_ID>",
        "AZURE_CLIENT_ID": "<AZURE_CLIENT_ID>",
        "AZURE_CLIENT_SECRET": "<AZURE_CLIENT_SECRET>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "microsoft-fabric-server-snahrup": {
      "command": "npx",
      "args": [
        "-y",
        "@strainprint/microsoft-fabric-mcp"
      ],
      "env": {
        "AZURE_TENANT_ID": "<AZURE_TENANT_ID>",
        "AZURE_CLIENT_ID": "<AZURE_CLIENT_ID>",
        "AZURE_CLIENT_SECRET": "<AZURE_CLIENT_SECRET>"
      }
    }
  }
}

Environment variables

AZURE_TENANT_ID
AZURE_CLIENT_ID
AZURE_CLIENT_SECRET

Replace the placeholders with your own credentials and keep them out of version control.

Setup

Environment variables

Related