Fabric Workspace Reader

Python MCP Server DXT PBIR License

MCP server for exploring Microsoft Fabric and Power BI workspaces. Available as standalone server and Desktop Extension (DXT).

Requires authentication to access Power BI workspaces (Azure CLI or Personal Access Token).

Quick Start

For Claude Desktop Users (Easiest)

Prerequisites: Python 3.8+ must be installed and in your PATH

• Mac/Linux: Usually pre-installed as python3. Use the _python3 verison.
• Windows: Download from python.org - during installation, check "Add Python to PATH". Use the _python version.

1. Download appropriate .dxt file from releases
2. Double-click to install in Claude Desktop
3. Configure authentication (see Authentication section)

For Other MCP Clients

1. Install dependencies:

pip install -r requirements.txt

2. Configure your MCP client to use this server. Example for VS Code:

{
  "mcpServers": {
    "fabric-workspace-reader": {
      "command": "python3",
      "args": ["path/to/fabric-workspace-reader-mcp.py"]
    }
  }
}

3. Authenticate using one of the supported methods:

• Personal Access Token
• Azure CLI

4. Start using the server through your MCP client.

5. For enhanced functionality, use with related MCP servers:

   • Fabric Model Reader MCP: Analyze semantic models and execute DAX queries
   • Fabric Report MCP: Manage report lifecycle and content manipulation

Authentication

The extension supports three authentication methods:

• Azure CLI: az login (recommended)
• Environment Variable: Set POWERBI_TOKEN
• System Keyring: Store token securely in system keyring

Without authentication, the extension will not be able to access any Power BI workspaces.

Available Tools

list_workspaces

List all accessible Microsoft Fabric workspaces.

Example usage:

list_workspaces()

get_workspace_contents

Get detailed information about items in a specific workspace.

Parameters:

• workspace_id (required): The workspace ID

Example usage:

get_workspace_contents(workspace_id="12345678-1234-1234-1234-123456789012")

How to Contribute

1. Fork the repository
2. Create a feature branch (git checkout -b feature/amazing-feature)
3. Make your changes following the existing patterns
4. Test your changes with sample workspaces
5. Commit your changes (git commit -m 'Add amazing feature')
6. Push to the branch (git push origin feature/amazing-feature)
7. Open a Pull Request

License

This project is licensed under a Non-Commercial License. See LICENSE for details.

Troubleshooting

Common Issues

Authentication failures:

• Run az login to authenticate with Azure CLI
• Verify you have access to Microsoft Fabric workspaces
• Check that POWERBI_TOKEN environment variable is set correctly

Workspace access denied:

• Ensure you have appropriate permissions for the workspace
• Verify the workspace exists and is accessible
• Check that you're using the correct workspace ID

Empty workspace listings:

• Confirm you have access to at least one Fabric workspace
• Verify authentication credentials are valid
• Check network connectivity to Microsoft Fabric endpoints

Security & Privacy Disclaimer

This software was created by me for me. I am sharing it for educational and personal use.

THIS SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. THE USER ASSUMES ALL RESPONSIBILITY AND RISK FOR THE USE OF THIS SOFTWARE.

DATA SECURITY AND PRIVACY: This extension accesses Microsoft Fabric and Power BI data using your provided credentials. The author assumes NO responsibility for data security, privacy, or confidentiality. Users are SOLELY responsible for:

• Protecting their authentication credentials
• Ensuring compliance with their organization's data policies
• Managing access to sensitive or confidential data
• Any data breaches or unauthorized access resulting from use of this extension

By using this code, you acknowledge that you are fully responsible for all data security and privacy implications.

AI Disclaimer

The code and docs in this repo were generated with the help of Claude Sonnet 4, Claude Opus 4, and Gemini 2.5 Pro using various agentic coding tools.