Excel Power Pivot Mcp

Name: Excel Power Pivot Mcp
Author: back1ply

@back1ply

Excel Power Pivot Mcp について

A Model Context Protocol (MCP) server that enables AI assistants to interact with Excel Power Pivot data models. Create and manage DAX measures, relationships, and more through natural language.

#excel #power-pivot #dax

基本情報

カテゴリ

その他

トランスポート

stdio

公開者

back1ply

投稿者

Back1Ply

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "excel-powerpivot": {
      "command": "C:/path/to/ExcelPowerPivotMcp.exe"
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is Excel Power Pivot MCP Server?

A Model Context Protocol server that enables AI assistants to interact with Excel Power Pivot data models. It allows creating and managing DAX measures, relationships, and more through natural language, targeting users who work with Excel Power Pivot.

How to use Excel Power Pivot MCP Server?

Download the latest ExcelPowerPivotMcp.exe from the Releases page and configure your MCP client (Claude Desktop, Cursor, or Antigravity) with the path to the executable. Open an Excel workbook with a Power Pivot data model, then the AI assistant can discover and connect to it automatically using tools like discover_workbooks and connect_workbook.

Key features of Excel Power Pivot MCP Server

Discover and connect to open Excel Power Pivot workbooks
Execute DAX queries and preview table data
Create, update, and delete DAX measures with auto-formatting
Create, delete, and activate/deactivate table relationships
List tables, columns, measures, relationships, hierarchies, KPIs, and dependencies
Add Excel tables to data model and refresh tables

Use cases of Excel Power Pivot MCP Server

Create and manage DAX measures via natural language conversation
Explore and document the data model structure (tables, relationships, measures)
Run ad-hoc DAX queries to preview data and test calculations
Add Excel tables to the data model and refresh model data
Establish or modify table relationships programmatically

FAQ from Excel Power Pivot MCP Server

What are the system requirements?

Windows 10/11 and Microsoft Excel 2013+ with Power Pivot enabled are required.

How do I connect to a workbook?

First open the workbook in Excel, then use the connect_workbook tool after discovering open workbooks with discover_workbooks.

What features are not available in Excel Power Pivot through this server?

Calculation Groups, Perspectives, Row-Level Security, and DEFINE COLUMN in DAX queries are not supported in Excel Power Pivot.

Can I create calculated columns via this server?

No, creating, updating, or deleting calculated columns is not possible via the MCP server due to COM API restrictions; use the Power Pivot window instead.

Is there a risk of data loss?

Yes, the tool modifies Excel Power Pivot data models directly. Maintain backups of your Excel files before using the tool. The author is not responsible for any data loss or damage.