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.
“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 GitHub stars and 1 commit on main in the last 30 days. Tier 2 placement reflects the modest cadence; the Microsoft official-vendor signal carries the score.”
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 TOOLS AVAILABLE
OUR ASSESSMENT
- 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
ADOPTION METRICS
// Reading this715 stars on the microsoft/powerbi-modeling-mcp repo. 1 commit on main in the last 30 days.
// Reading thisPairs with the Google Analytics MCP and existing dbt MCP in the data category for analytics workflows.
SOURCES & VERIFICATION
We don't take any single directory's word for it. Before scoring, we cross-reference 4 public MCP sources, install the server ourselves against the clients we cover, and record when we last re-verified.
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
Web intelligence layer that turns any URL into LLM-optimised markdown. Handles JavaScript rendering, pagination, and structured extraction so your agent reads the live web instead of stale training data.
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.
Bright Data MCP
Web data extraction over the Bright Data network with two operating modes: Rapid Mode (free, basic search and scrape) and Pro Mode (60+ structured-dataset tools targeting Amazon, LinkedIn, Walmart, Instagram, and more).
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.