Excel Power Pivot MCP Server

@back1ply

Basic information

About Excel Power Pivot MCP Server

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

Excel Power Pivot MCP Server config

Add this server to your MCP-compatible client using the configuration below.

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

Excel Power Pivot MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

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.

Comments

More Other MCP servers

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K