PowerBI development with Claude Code

Combining PowerBI and Claude Code can help to speed up report development. I’ve recorded a 4 part mini-series to demonstrate the usage of Claude Code in report project. This is not about vibe coding reports, but to delegate boring coding and modeling tasks.

Part 1: Use PowerBI Project Files with Claude Code in VSCode, create the initial Claude.md file and let Claude generate a source database documentation:

Part 2: Use Claude Code to modify the data model. Generate a date dimension table and use the planning mode:

Part 3: Create a reusable skill for a date dimension table and test it in another report

Part 4: Generate DAX Measures from requiremet prompt to summarize the Totals and Year-by-year comparison without telling Claude Code which formulars to use:

MCP for Dataverse with Claude Desktop

The power of MCP (Model Context Protocol) allows you to connect an AI application like Copilot oder Claude to an Application, in a way that the AI application can work with the connected system in the background. For example, the MCP impementation for Microsoft Dataverse allows an AI application to query and manipulate records in the Dataverse. Sounds simple but here is the magic:

  • Query dataverse in natural language 💬 e.g. “Find me all german customers”
  • Chat in your natural language no matter how Dataverse was setup in the background, e.g. talk in English 🇬🇧 and let AI work an a German 🇩🇪 dataverse installation
  • Let the AI investigate the database structure 🔍. If you dont provide information how tables are related it will find out by its own,