# 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)
```bash
npm install -g @strainprint/microsoft-fabric-mcp
```
### From Source
```bash
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:
```env
# 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`):
```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
```javascript
{
"datasetId": "dataset-guid",
"query": "EVALUATE TOPN(10, 'Sales')"
}
```
### `refresh_dataset`
Trigger a dataset refresh
```javascript
{
"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](https://github.com/strainprint) for the MCP community.
Special thanks to Anthropic for the Model Context Protocol specification.
