Power BI Modeling MCP
Official Microsoft MCP server for Power BI semantic modelling. Bring Power BI semantic model capabilities to AI agents: tables, columns, measures, relationships, DAX queries. 715 stars and 1 commit on main in the last 30 days.
INSTALL THIS SERVER
{
"mcpServers": {
"powerbi-modeling": {
"command": "npx",
"args": [
"-y",
"@microsoft/powerbi-modeling-mcp"
]
}
}
}
{
"mcpServers": {
"powerbi-modeling": {
"command": "npx",
"args": [
"-y",
"@microsoft/powerbi-modeling-mcp"
]
}
}
}
{
"mcpServers": {
"powerbi-modeling": {
"command": "npx",
"args": [
"-y",
"@microsoft/powerbi-modeling-mcp"
]
}
}
}
{
"mcpServers": {
"powerbi-modeling": {
"command": "npx",
"args": [
"-y",
"@microsoft/powerbi-modeling-mcp"
]
}
}
}
{
"mcpServers": {
"powerbi-modeling": {
"command": "npx",
"args": [
"-y",
"@microsoft/powerbi-modeling-mcp"
]
}
}
}
6 SELECTED TOOLS
OUR ASSESSMENT
Microsoft maintains an official MCP server for Power BI semantic modelling. Tool surface covers DAX query execution, plus admin operations for tables, columns, measures, relationships, and dataset metadata. Useful for analytics workflows where the agent inspects or queries semantic models inside Power BI.
- Official Microsoft maintenance.
- 715 GitHub stars and MIT licence.
- Semantic modelling focus: tables, columns, measures, relationships, DAX queries.
- Useful for analytics workflows where the agent inspects or queries semantic models inside Power BI.
- 1 commit on main in the last 30 days, modest cadence for Tier 1.
- Power BI tenant credentials required: the MCP runs against a Microsoft Entra ID-authenticated session.
- DAX query authoring assumes the agent understands Power BI semantic conventions.
The MCP uses Microsoft Entra ID authentication for Power BI workspace access. Scope the agent service principal to the specific workspaces and datasets needed. DAX queries can return large result sets; budget the agent context window accordingly.
Power BI customers who want agents to query semantic models with DAX from inside the editor; analytics teams that maintain Power BI semantic models and want agent-driven inspection of tables, columns, measures, and relationships; Microsoft-aligned organisations on Microsoft Entra ID.
TECHNICAL DETAILS
RECORDED ADOPTION METRICS
Saved directory snapshots. Record last checked MAY 3, 2026. The review date above does not refresh these figures.
// Recorded note715 stars on the microsoft/powerbi-modeling-mcp repo. 1 commit on main in the last 30 days.
// Recorded notePairs with the Google Analytics MCP and existing dbt MCP in the data category for analytics workflows.
SOURCES & RECORDED CHECKS
These are the directory listings and check details held in this record. Client compatibility, directory listings and installation testing are separate signals. Recorded client names describe the scope of a check; they do not establish a security assessment or a recurring test schedule.
The same server, 4 different lenses. We reconcile these signals into our editorial score, which is why our number sometimes diverges from a directory-aggregate star count.
| Source | Their rating | Their star count | Their downloads | Last synced |
|---|---|---|---|---|
| AutomationSwitch This page | 4editorial | 715 | — | MAY 3, 2026 |
| PulseMCP | — unrated | unavailable | unavailable | MAY 3, 2026 |
| MCP.so | — unrated | unavailable | unavailable | MAY 3, 2026 |
| Glama | — unrated | unavailable | unavailable | MAY 3, 2026 |
| Official MCP Registry | — unrated | unavailable | unavailable | MAY 3, 2026 |
// Counts are directory-reported; we don't adjust them. Discrepancies usually come from different snapshot times or star-caching.
OTHER DATA / ANALYTICS MCP SERVERS
Firecrawl
Official Firecrawl MCP server for web search, page extraction and site discovery, with Markdown and structured content workflows.
Google Analytics MCP
Official Google MCP server for Google Analytics 4. Query reports, dimensions, metrics, custom audiences, and admin entities through MCP. 1,981 GitHub stars and 5 commits on main in the last 30 days. Apache-2.0.
Apify Actors MCP
Apify Actors as MCP tools: 6,000+ web scrapers, automation actors, and AI agents callable from Claude, Cursor, or any MCP client. Hosted streamable transport at https://mcp.apify.com plus stdio via npx. Dynamic actor discovery at runtime.
dbt MCP
Official dbt Labs MCP server covering SQL execution, Semantic Layer queries, Discovery API, dbt CLI, Admin API, dbt Codegen, dbt LSP, and Product Docs. 41 commits on main in the last 30 days, joint top cadence in this batch.
Tableau MCP
Tableau's official MCP server. Lets agents see and understand Tableau workbooks, datasources, and views over MCP. 259 GitHub stars and 12 commits on main in the last 30 days.
AntV Chart MCP
Visualization MCP and skills with 25+ chart types using AntV. Generate charts and analyse data from inside agents. 4,047 GitHub stars and 2 commits on main in the last 30 days.
DISCUSS YOUR
MCP REQUIREMENTS.
Evaluating a server, scoping an internal deployment, or working out whether MCP is the right fit at all. Start the conversation and we will point you at the right piece of the ecosystem.