Fabric-MCP-Server

sherwinpaul/Fabric-MCP-Server

3.1

If you are the rightful owner of Fabric-MCP-Server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

Custom MCP server implementation for Microsoft Fabric, enabling AI assistants to interact with Fabric workspaces, datasets, and analytics pipelines.

Microsoft Fabric MCP Server Integration

Custom MCP (Model Context Protocol) server implementation for Microsoft Fabric, enabling AI assistants to interact with Fabric workspaces, datasets, and analytics pipelines.

Overview

This project implements MCP server tools for Microsoft Fabric integration, allowing LLMs and AI assistants to access and manipulate Fabric resources through a standardized protocol.

Key Features

  • Fabric Workspace Integration: Connect AI assistants to Fabric workspaces
  • DAX Query Support: Execute DAX queries through MCP
  • Data Pipeline Automation: Trigger and monitor Fabric pipelines
  • Semantic Model Access: Query semantic models and datasets
  • Real-time Analytics: Enable AI-driven insights from Fabric data

Tech Stack

  • .NET / C#
  • Microsoft Fabric SDK
  • Model Context Protocol (MCP)
  • Azure integration

Use Cases

  1. AI-Powered Analytics: Natural language queries on Fabric datasets
  2. Automated Reporting: AI-generated reports from Fabric data
  3. Pipeline Orchestration: LLM-driven data pipeline management
  4. Data Discovery: AI-assisted exploration of Fabric workspaces
  5. BI Integration: Connect business intelligence with AI assistants

Business Impact

  • Democratize data access through natural language
  • Accelerate analytics workflows
  • Enable AI-driven business insights
  • Streamline data pipeline management

Project Structure

Fabric MCP/
├── mcp/                  # MCP server implementation
├── MCP Fabric understanding.docx
├── MCP- Agentic AI.pptx
└── README.md

Integration

Works with:

  • Claude Code
  • GitHub Copilot
  • VS Code with MCP support
  • Other MCP-compatible AI assistants

Future Enhancements

  • Additional Fabric API coverage
  • Enhanced DAX query optimization
  • Real-time streaming data support
  • Custom connector development
  • Multi-workspace orchestration

License

Proprietary - For portfolio demonstration

Domain: AI Integration, Business Intelligence, Microsoft Fabric Protocol: Model Context Protocol (MCP) Status: Production-Ready