Microsoft Fabric MCP Server

A Model Context Protocol (MCP) server that enables AI assistants like Claude to interact with Microsoft Fabric and Power BI services.

Features

• 📊 Power BI Integration

  • List and query datasets
  • Execute DAX queries
  • Refresh datasets
  • Manage workspaces

• 🏭 Microsoft Fabric Support

  • Create and manage notebooks
  • Upload data to warehouses
  • Access Fabric workspaces

Installation

Via NPM (Recommended)

npm install -g @strainprint/microsoft-fabric-mcp

From Source

git clone https://github.com/strainprint/microsoft-fabric-mcp.git
cd microsoft-fabric-mcp
npm install
npm run build

Configuration

1. Azure App Registration

Create an Azure App Registration with the following permissions:

• Power BI Service (Delegated or Application):
  • Dataset.Read.All
  • Workspace.Read.All
  • Dataset.Execute.All (for DAX queries)

2. Power BI Tenant Settings

Enable in Power BI Admin Portal → Tenant settings:

• "Allow service principals to use Power BI APIs"
• "Service principals can access read-only admin APIs"

3. Environment Variables

Create a .env file or set environment variables:

# Required
AZURE_TENANT_ID=your-tenant-id
AZURE_CLIENT_ID=your-client-id
AZURE_CLIENT_SECRET=your-client-secret

# Optional
POWERBI_WORKSPACE_ID=workspace-id  # If not set, uses workspace-agnostic endpoints

4. Claude Desktop Configuration

Add to your Claude Desktop config (%APPDATA%\Claude\claude_desktop_config.json):

{
  "mcpServers": {
    "MicrosoftFabric": {
      "command": "npx",
      "args": [
        "-y",
        "@strainprint/microsoft-fabric-mcp"
      ],
      "env": {
        "AZURE_TENANT_ID": "your-tenant-id",
        "AZURE_CLIENT_ID": "your-client-id",
        "AZURE_CLIENT_SECRET": "your-client-secret",
        "POWERBI_WORKSPACE_ID": "optional-workspace-id"
      }
    }
  }
}

Usage

Once configured, Claude can use commands like:

• "List my Power BI datasets"
• "Execute this DAX query on dataset X"
• "Refresh the sales dataset"
• "Show me all workspaces"

Available Tools

get_workspaces

Get all accessible Power BI/Fabric workspaces

get_powerbi_datasets

List all datasets in the configured workspace

execute_dax_query

Execute DAX queries against a dataset

{
  "datasetId": "dataset-guid",
  "query": "EVALUATE TOPN(10, 'Sales')"
}

refresh_dataset

Trigger a dataset refresh

{
  "datasetId": "dataset-guid"
}

create_notebook

Create a new Fabric notebook

upload_to_datawarehouse

Upload data to a Fabric data warehouse

Troubleshooting

403 Forbidden Errors

1. Check Service Principal Permissions

   • Ensure the service principal is added to the Power BI workspace
   • Verify API permissions in Azure Portal

2. Power BI Tenant Settings

   • Confirm service principals are allowed to use Power BI APIs
   • Check if the service principal is in the allowed security group

3. Token Issues

   • Verify client secret hasn't expired
   • Ensure correct tenant ID

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

License

MIT © Strainprint Technologies

Credits

Developed by Steve Adams for the MCP community.

Special thanks to Anthropic for the Model Context Protocol specification.