Skip to main content
Glama

powerbi-mcpb

MCP Bundle for local Power BI report files (.pbix, .pbip, .pbit). No Azure, no cloud API, no sign-in.


Architecture

powerbi-mcpb/
├── src/
│   ├── index.ts
│   ├── helpers.ts
│   ├── local/
│   │   ├── paths.ts          # LOCAL_REPORTS_DIR
│   │   ├── scan.ts           # Find reports on disk
│   │   ├── pbixArchive.ts    # Unzip .pbix / .pbit
│   │   ├── pbixReader.ts
│   │   └── pbipReader.ts     # Read .pbip project folders
│   └── tools/
│       └── localReports.ts   # list_local_reports, get_local_report, ...
├── manifest.json
└── ...

Legacy cloud tools (workspaces.ts, reports.ts, datasets.ts) remain in the repo but are not registered — they targeted api.powerbi.com.


Related MCP server: powerbi-mcp

Prerequisites

  • Node.js 18+

  • Power BI report files in a folder on disk


Dev setup

npm install
npm run build
npm run bundle
$env:LOCAL_REPORTS_DIR = "C:\Your\Reports"
npm start

Install (MCP bundle)

Pick your reports folder when prompted (local_reports_folder). Rebuild with npm run pack.


Tools

Tool

Description

list_local_reports

Scan folder for .pbix, .pbip, .pbit

get_local_report

Pages, tables (if available), archive listing

list_local_model_tables

Tables/columns from .pbip / .pbit


Authentication

None. Files are read from disk only.

Related MCP Connectors

Related MCP Servers

  • A
    license
    Not graded
    quality
    A
    maintenance
    MCP server for creating, editing, and evaluating Power BI (.pbix/.pbit) files without Power BI Desktop. Supports 101 tools including report creation, data sources, DAX measures, and file manipulation.
    1,313 PyPI
    23
    MIT
  • A
    license
    Not graded
    quality
    D
    maintenance
    MCP server for connecting to Microsoft Fabric and Power BI semantic models, enabling workspace browsing, dataset management, TMSL retrieval, DAX queries, model creation/editing, and includes a Best Practice Analyzer with 71 rules.
    2
    MIT
  • A
    license
    B
    quality
    B
    maintenance
    MCP server for interacting with local Power BI Desktop and .pbip projects, enabling DAX queries, model documentation, measure editing, and PBIR visual management via natural language.
    90
    84 PyPI
    1
    Apache 2.0