Claude + Power BI Integration 🧠 MASSIVE Breakthrough via MCP 💥 (Nov 2025 Update)
The future of Power BI modeling is here. 🚀
With the November 2025 Power BI update, you can now connect Claude AI directly to your Power BI semantic models using the Modeling MCP extension for VS Code — enabling Claude to analyze, edit, and auto-generate model components in seconds.
In this video, I walk through exactly how to set up the MCP connection and give you proven prompt templates to dramatically enhance your Power BI models — including DAX generation, metadata cleanup, documentation, and optimization.
🔍 Why This Matters
This is the most powerful Power BI modeling update in years.
You can now automate 90% of your semantic model tuning and documentation with Claude — no copy/pasting, no hacks, no guesswork.
This is especially impactful for:
Power BI Admins
BI Engineers
Fabric Developers
Data Modeling Teams
Power BI COE Leaders
🤖 Game-Changing Prompts to Use with Claude
Once connected to an open Power BI model, use these prompts for instant modeling upgrades:
✅ Connect to Open Power BI Desktop Model
✅ Create a new empty table to hold calculations, create an aggregate amount calc for every sales status value (Returned or Sold), create a net sales calc, and also create a comprehensive group of monthly time intelligence measures for all measures created. Remove/hide any placeholder fields in the new table.
✅ Analyze my model’s naming conventions and suggest renames to ensure consistency.
✅ Hide all foreign key columns (ProductID, StoreID) and keep only user-friendly display names visible
✅ Hide foreign key columns (e.g., ProductID) and keep display names
✅ Add descriptions to all measures, columns, and tables to clearly explain their purpose and explain the logic behind the DAX code in simple, understandable terms.
✅ Create user hierarchies for drill-down navigation
✅ Analyze my data types and optimize them for better compression and performance, change them as needed
✅ Generate a Markdown document (.md) that provides complete, professional documentation for the Power BI Semantic Model, including a data dictionary. Use a simple mermaid diagram to ilustrate the table relationships; Document each measure including the DAX code and a description of the business logic using business friendly names; Document the data sources by analyzing the Power Query code.
🔌 Step-by-Step Installation & Setup
💻 Install Links:
Power BI Nov 2025 Feature Summary
https://powerbi.microsoft.com/en-us/b...
Modeling MCP GitHub
https://github.com/microsoft/PowerBI-...
Visual Studio Code (VS Code)
https://code.visualstudio.com/
MCP Extension for VS Code
https://marketplace.visualstudio.com/...
Claude Desktop App
https://www.claude.com/download
🛠️ Setup Notes:
Locate the MCP server install path:
%USERPROFILE%\.vscode\extensions
Example:
C:\Users\yourname\.vscode\extensions\analysis-services.powerbi-modeling-mcp-0.1.9-win32-x64
Update your Claude config.json file with the correct server path and arguments:
{
"mcpServers": {
"powerbi-modeling-mcp": {
"command": "Paste Path Here Replace \ with \\",
"args": ["--start"],
"type": "stdio"
}
}
}
sample..
{
"mcpServers": {
"powerbi-modeling-mcp": {
"command": "C:\\Users\\rlau\\.vscode\\extensions\\analysis-services.powerbi-modeling-mcp-0.1.9-win32-x64\\server\\powerbi-modeling-mcp.exe",
"args": ["--start"],
"type": "stdio"
}
}
}
✅ Restart your machine after configuration.
🔍 Power BI MCP Chapters
00:00 - Claude MCP PBI Intro
00:58 - Overview of Connection Process
02:43 - Prompt 1 - Create Calcs
04:34 - Prompt 2 - Rename Fields
06:20 - Prompt 3 - Create Folder Structure
07:20 - Prompt 4 - Hide Foreign Keys
08:13 - Prompt 5 - Populate All Descriptions
10:08 - Prompt 6 - Create Hierarchies
11:10 - Prompt 7 - Data Type Optimization
14:47 - ** CONNECTION STEPS **
#powerbi #powerbidesktop #powerbibro #powerbitutorial #claude #mcp
#datavisualization #dataanalytics #microsoftfabric #modelcontextprotocol