Power BI now integrates with Claude, a powerful AI engine. Using Claude with Power BI MCP Servers can automate model building, create measures, clean and organize tables, and even generate full documentation. In this guide, you’ll learn exactly how to connect Claude to Power BI and use seven game-changing prompts to streamline your data workflow.
Get expert Power BI training here.
Why Connect Claude to Power BI?
Claude is a large language model that plugs directly into your Power BI models. Once connected, it can:
- Create calculation tables and measures automatically
- Organize tables, rename fields, and create folders
- Hide foreign keys and populate descriptions for metadata
- Build hierarchies for drill-down navigation
- Optimize data types for performance and compression
- Generate a full professional-grade data dictionary
These features save hours of manual work, reduce errors, and enhance data governance.
Step 1: Install Required Tools
Before connecting Claude, make sure you have the following installed:
- Visual Studio Code – download and install from the official site.
- Power BI Modeling MCP Server – search for it in VS Code Extensions and install.
- Claude Desktop – download the Windows version from the link in the video description.
Step 2: Configure Claude to Work with MCP Servers
- Open Claude Desktop and navigate to Settings → Developer Tab.
- Edit the configuration file to include the path to the MCP server.
- Make sure to change single slashes (
\) to double slashes (\\).
- Make sure to change single slashes (
- Restart Claude and your computer. Once restarted, Claude will detect Power BI MCP Server automatically.
Step 3: Connect to a Power BI Model
- Open the Power BI Desktop file you want to enhance.
- In Claude, use the connect command to link to your open model.
- Once connected, Claude is ready to run your prompts and optimize your model.
7 Game-Changing Claude Prompts
Here’s a quick overview of the most powerful prompts demonstrated in the video:
- Create Calculation Tables – Auto-generate measures like net sales, aggregate totals, and time intelligence.
- Rename Fields – Standardize naming conventions for all tables and columns.
- Create Folder Structure – Organize fields into nested folders for better usability.
- Hide Foreign Keys – Clean the model by hiding irrelevant IDs.
- Populate All Descriptions – Automatically generate a data dictionary for every measure, column, and table.
- Create Hierarchies – Build drill-down hierarchies for dates, products, and other dimensions.
- Optimize Data Types – Improve performance, compression, and query speed automatically.
Step 4: Generate Full Documentation
Once the above prompts are executed, Claude can produce a complete markdown document including:
- Semantic model overview
- Table relationships with diagrams
- Detailed descriptions of each measure and DAX code
- Business-friendly documentation ready to share with your team
This process, which traditionally takes days, now takes minutes.
Conclusion
Connecting Claude AI to Power BI MCP Servers is a game-changer for analysts and data teams. From automating calculations to creating enterprise-grade documentation, Claude accelerates your workflow and ensures accuracy.
