Fabric Analytics
The Fabric-Analytics-MCP server enables AI agents to interact directly with Microsoft Fabric using natural language. It transforms complex data engineering tasks—such as workspace management, data exploration, and job execution—into intuitive, conver
What is Fabric Analytics?
Fabric Analytics is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to fabric-analytics-mcp server enables ai agents to interact directly with microsoft fabric using natural language. it transforms complex data engineering tasks—such as workspace management, data explora...
The Fabric-Analytics-MCP server enables AI agents to interact directly with Microsoft Fabric using natural language. It transforms complex data engineering tasks—such as workspace management, data exploration, and job execution—into intuitive, conver
This server falls under the Analytics category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- The Fabric-Analytics-MCP server enables AI agents to interac
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx fabric-analytics-mcpConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Fabric Analytics
The Microsoft Fabric Analytics MCP Server is a comprehensive Model Context Protocol server that gives AI assistants direct access to Microsoft Fabric's data platform through 52 tools. It covers full workspace lifecycle management, notebook creation and execution, Spark job monitoring via the Livy API, capacity assignment, role-based access control, Git integration, and automated migration of Spark workloads from Azure Synapse Analytics to Fabric. Teams use it to manage their entire Fabric estate through natural language without leaving their AI assistant.
Prerequisites
- Node.js 18 or higher
- A Microsoft Fabric workspace with at least Contributor access
- A valid Fabric bearer token (obtainable from app.powerbi.com/embedsetup) or Azure service principal credentials (FABRIC_CLIENT_ID, FABRIC_CLIENT_SECRET, FABRIC_TENANT_ID)
- For Spark monitoring: Livy API access enabled on the Fabric capacity
- An MCP-compatible client such as Claude Desktop or GitHub Copilot
Clone and build the server
Clone the Fabric Analytics MCP repository, install Node.js dependencies, and build the TypeScript project.
git clone https://github.com/santhoshravindran7/Fabric-Analytics-MCP.git
cd Fabric-Analytics-MCP
npm install && npm run buildObtain a Fabric bearer token
Navigate to https://app.powerbi.com/embedsetup in your browser to generate a bearer token for your Fabric workspace. Tokens expire after approximately one hour. For long-running setups consider using service principal credentials instead.
Configure environment variables
Set the required environment variables. The simplest method for Claude Desktop is the bearer token approach, which avoids interactive OAuth flows that time out in the sandboxed environment.
FABRIC_AUTH_METHOD=bearer_token
FABRIC_TOKEN=your_bearer_token_here
FABRIC_WORKSPACE_ID=your_workspace_id
ENABLE_HEALTH_SERVER=falseAdd the server to Claude Desktop
Edit claude_desktop_config.json to register the Fabric Analytics MCP server with your credentials.
{
"mcpServers": {
"fabric-analytics": {
"command": "node",
"args": ["C:\\path\\to\\Fabric-Analytics-MCP\\build\\index.js"],
"env": {
"FABRIC_AUTH_METHOD": "bearer_token",
"FABRIC_TOKEN": "your_bearer_token_here",
"FABRIC_WORKSPACE_ID": "your_workspace_id",
"ENABLE_HEALTH_SERVER": "false"
}
}
}
}Restart Claude Desktop
Fully quit and relaunch Claude Desktop. The 52 Fabric tools should appear in the available tool list. If you see a 60-second timeout, verify that FABRIC_AUTH_METHOD is set to bearer_token.
Fabric Analytics Examples
Client configuration
Claude Desktop config using bearer token authentication — the recommended approach to avoid interactive OAuth timeouts.
{
"mcpServers": {
"fabric-analytics": {
"command": "node",
"args": ["C:\\path\\to\\Fabric-Analytics-MCP\\build\\index.js"],
"env": {
"FABRIC_AUTH_METHOD": "bearer_token",
"FABRIC_TOKEN": "your_bearer_token_here",
"FABRIC_WORKSPACE_ID": "your_workspace_id",
"ENABLE_HEALTH_SERVER": "false"
}
}
}
}Prompts to try
These prompts exercise workspace management, Spark monitoring, and migration capabilities.
- "Create a new workspace called 'Analytics-Q1-2025' and assign it to our premium capacity"
- "List all workspaces in my tenant and show their capacity assignments"
- "Add user [email protected] as Admin to the Analytics workspace"
- "List all running Spark applications across all workspaces and cancel any failed ones"
- "Discover assets from my Synapse workspace 'analytics-synapse' and show how the notebooks would be transformed"
- "Migrate all notebooks from Synapse workspace 'analytics-synapse' to Fabric workspace and create a lakehouse called 'MigratedData'"Troubleshooting Fabric Analytics
Claude Desktop times out for 60 seconds on startup
This is caused by interactive OAuth flows blocking the sandboxed environment. Set FABRIC_AUTH_METHOD to bearer_token and provide FABRIC_TOKEN with a valid token from app.powerbi.com/embedsetup. The server automatically prioritizes this variable over interactive flows.
Bearer token expires during a session
Fabric bearer tokens expire after approximately one hour. Regenerate a fresh token from app.powerbi.com/embedsetup and update the FABRIC_TOKEN value in your config, then restart Claude Desktop. For production use, configure service principal credentials (FABRIC_CLIENT_ID, FABRIC_CLIENT_SECRET, FABRIC_TENANT_ID) which auto-refresh.
Tool calls return 'workspace not found' errors
Verify that FABRIC_WORKSPACE_ID contains the correct GUID for your workspace (visible in the Fabric portal URL). Ensure your bearer token or service principal has at least Contributor access to that workspace.
Frequently Asked Questions about Fabric Analytics
What is Fabric Analytics?
Fabric Analytics is a Model Context Protocol (MCP) server that fabric-analytics-mcp server enables ai agents to interact directly with microsoft fabric using natural language. it transforms complex data engineering tasks—such as workspace management, data exploration, and job execution—into intuitive, conver It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Fabric Analytics?
Follow the installation instructions on the Fabric Analytics GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Fabric Analytics?
Fabric Analytics works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Fabric Analytics free to use?
Yes, Fabric Analytics is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
Fabric Analytics Alternatives — Similar Analytics Servers
Looking for alternatives to Fabric Analytics? Here are other popular analytics servers you can use with Claude, Cursor, and VS Code.
OpenMetadata
★ 14.0kOpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.
Superset
★ 10.9kAn MCP server that provides AI assistants with full access to Apache Superset instances, enabling interaction with dashboards, charts, datasets, databases, and SQL execution capabilities.
Horizon
★ 4.4k📡 Your own AI-powered news radar. Generates daily briefings in English & Chinese. | 用 AI 构建你专属的新闻雷达
MCP Server Chart
★ 4.1kEnables generation of 25+ types of charts and data visualizations using AntV, including bar charts, line charts, maps, mind maps, and specialized diagrams like fishbone and sankey charts. Supports both statistical charts and geographic visualizations
Muapi CLI
★ 997Official CLI for muapi.ai — generate images, videos & audio from the terminal. MCP server, 14 AI models, npm + pip installable.
Weather MCP Server
★ 907Weather Data Fetcher MCP server built with Node.js, MCP SDK, and Zod. Provides weather details like temperature and forecast for cities such as Noida and Delhi via a registered tool. Simplifies API integration, enabling structured responses for clien
Browse More Analytics MCP Servers
Explore all analytics servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Fabric Analytics in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Fabric Analytics?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.