Moedim.Mcp.Fabric

Model Context Protocol (MCP) server that exposes Microsoft Fabric semantic models, tables, and DAX queries to AI assistants.

"Moedim" is a Hebrew word that translates to "feast" or "appointed time." The feasts are signals and signs to help us know what is on the heart of HaShem.

Hire me

Please send email if you consider to hire me.

Give a Star! :star:

If you like or are using this project to learn or start your solution, please give it a star. Thanks!

Features

• Semantic Model Discovery: List workspaces, datasets, tables, and columns exposed via Fabric APIs.
• DAX Execution: Run DAX queries against Fabric semantic models with optional dataset overrides.
• Aggregations & Distincts: Built-in helpers for SUM/AVG/COUNT/MIN/MAX and distinct values.
• Typed Responses: Structured models for query results, metadata, and formatted text outputs.
• MCP-Ready Tools: Five MCP tools with full metadata/description attributes for better LLM guidance.

Quick Start

Installation

dotnet add package Moedim.Mcp.Fabric

Configuration

Provide configuration via appsettings.json or environment variables:

• Fabric:WorkspaceId (required)
• Fabric:DefaultDatasetId (optional)
• Fabric:ApiBaseUrl (default: https://api.powerbi.com/v1.0/myorg)
• Fabric:HttpTimeoutSeconds (default: 30)

Transport Modes

The server supports two transport modes:

Stdio Mode (Default)

Use stdio transport for local development with VS Code MCP extension:

dotnet run --project src/Moedim.Mcp.Fabric/Moedim.Mcp.Fabric.csproj

Or configure in your MCP client:

{
  "servers": {
    "Moedim.Mcp.Fabric": {
      "type": "stdio",
      "command": "dotnet",
      "args": ["run", "--project", "Moedim.Mcp.Fabric.csproj"],
      "cwd": "${workspaceFolder}/src/Moedim.Mcp.Fabric"
    }
  }
}

HTTP Mode

Use HTTP transport for stateless deployment or container environments:

# Default port 5000
dotnet run --project src/Moedim.Mcp.Fabric/Moedim.Mcp.Fabric.csproj --http

# Custom port
dotnet run --project src/Moedim.Mcp.Fabric/Moedim.Mcp.Fabric.csproj --http --port 8080

Or configure in your MCP client:

{
  "servers": {
    "Moedim.Mcp.Fabric": {
      "type": "http",
      "url": "http://localhost:5000/mcp"
    }
  }
}

For complete details on command-line options and environment variables, run:

dotnet run --project src/Moedim.Mcp.Fabric/Moedim.Mcp.Fabric.csproj --help

Or see QUICKSTART.md.

Available MCP Tools

The server exposes 10 powerful tools for interacting with Microsoft Fabric semantic models:

Data Query & Exploration

• query_semantic_model — Execute ad-hoc DAX queries against semantic models with optional dataset override
• list_semantic_models — Enumerate all datasets in the configured Fabric workspace
• get_semantic_model_metadata — Retrieve table and column schema information (requires Push API datasets)

Dataset Information

• get_dataset_details — Get comprehensive dataset metadata (name, owner, created date, storage mode, refresh settings, security, scale-out config)
• get_dataset_datasources — List all datasources configured for a dataset
• get_dataset_parameters — Retrieve mashup parameters defined in the dataset
• get_dataset_refresh_history — View refresh history entries with status and timing information
• get_dataset_users — List principals and their access rights to a dataset

Data Aggregation

• aggregate_data — Perform aggregation operations (SUM, AVG, COUNT, MIN, MAX) on columns
• get_distinct_values — Retrieve all unique values from a specified column

Local Development

dotnet build
dotnet run --project src/Moedim.Mcp.Fabric/Moedim.Mcp.Fabric.csproj

Debugging in VS Code: use the .NET: Debug MCP Server launch profile.

Packaging

• The NuGet package embeds the project README and uses the icon at img/icon.png.
• Pack with dotnet pack -c Release to produce the MCP server package.

License

MIT License. See LICENSE.

References

• text
• Model Context Protocol .NET Samples
• Create a minimal MCP server using C# and publish to NuGet
• modelcontextprotocol/csharp-sdk