Skip to content
Data MCP Directory

SIDE BY SIDE, read 10 Nov 2026

Power BI Modeling MCP Server and Tableau MCP, field by field: 21 and 40 tools named

Power BI Modeling MCP ServerTableau MCP

The same fourteen fields for both servers, read 10 Nov 2026.
FieldPower BI Modeling MCP ServerTableau MCP
Data toolPower BITableau
PublisherMicrosoftTableau (Salesforce)
KindOfficialOfficial
Repository or docsgithub.com/microsoft/powerbi-modeling-mcpgithub.com/tableau/tableau-mcp
Version or commit1.0.16.0.4
Last release6 Nov 20269 Nov 2026
TransportRemote and localRemote and local
AuthLocal: Microsoft Entra interactive sign-in (default) or service principal (client secret or certificate). Hosted: Entra ID as the signed-in user.Hosted: OAuth 2.1 with each user's own Tableau Cloud identity. Self-hosted: PAT (default), direct-trust (Connected Apps), OAuth, passthrough, or unified access tokens.
AccessConfigurableConfigurable
Tools listed21 named in the evidence40 named in the evidence
Tool definitions read atraw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.mdraw.githubusercontent.com/tableau/tableau-mcp/main/src/tools/web/getDatasourceMetadata/getDatasourceMetadata.ts
Context weight387 tokens for 21 tool definitions (21 with a description), measured from the README readNot measured: the source read on 10 Nov 2026 holds the definitions of 2 of the roughly 40 Tableau MCP tools (get-datasource-metadata and query-datasource), and one of those descriptions is imported from a file that was not read, so a measurement would cover a small part of the server.
StatusExists on 10 Nov 2026. Microsoft documents two Power BI MCP servers: the Authoring server (local GA over stdio from microsoft/powerbi-modeling-mcp, hosted preview at api.fabric.microsoft.com/v1/mcp/powerbi/authoring and Fabric IQ for answering questions over governed data; an earlier consumption MCP remains documented. Hosted authoring tool names are not published, so the tool list is the local server's.Exists on 10 Nov 2026 as tableau/tableau-mcp (npm @tableau/mcp-server) and as a hosted service at mcp.tableau.com; the schema file holds two of the tool source files (get-datasource-metadata, query-datasource); the full tool list comes from the docs intro page.
Read10 Nov 202610 Nov 2026

In one sentence each

  • Power BI Modeling MCP Server: Microsoft's authoring server reads and writes semantic-model objects (tables, columns, DAX measures, relationships, RLS roles, TMDL) under the user's Fabric permissions, with a read-only switch.
  • Tableau MCP: Tableau's server exposes data source metadata with calculation strings and Pulse metric definitions per signed-in user, plus, on Tableau+, a knowledge tool for lineage and impact.

The read facts, topic by topic

Each cell joins the facts read for that topic; the full list with sources is on each entry. Read 10 Nov 2026.
TopicPower BI Modeling MCP ServerTableau MCP
Publisher and releasesMicrosoft publishes the Power BI Authoring MCP Server in its own microsoft GitHub organization and documents it on Microsoft Learn. The latest GitHub release is v1.0.1 (previous v1.0.0, then beta tags), timestamped 6 Nov 2026. The npm package @microsoft/powerbi-modeling-mcp has latest 1.0.1 published 6 Nov 2026, and 1.0.0 on 25 Sep 2026. The local server is generally available and the hosted endpoint is in preview.Tableau publishes tableau-mcp as its official MCP server, and the repo README carries the 'Tableau Supported' support-level badge. The latest GitHub release is v6.0.4 (listed first on the releases page). The npm package @tableau/mcp-server has dist-tag latest 6.0.4, published 9 Nov 2026, under the Apache-2.0 license. The README badge states the support level as Tableau Supported.
Clients, auth and scopingThe hosted server prompts for Microsoft Entra sign-in on first tool call and then acts with the user's permissions. Fabric IQ, Microsoft's consumption server, answers questions over semantic models and respects permissions, row-level security and object-level security. Microsoft states that clients operate under the user's Fabric RBAC permissions.The hosted Tableau MCP at mcp.tableau.com uses OAuth 2.1 so each user signs in as themselves and per-user Tableau permissions are enforced. Authentication to the Tableau REST APIs is selectable between pat (default), direct-trust, oauth and passthrough. The Tableau docs state the authenticated user must have access to the published data sources the agent will use.
Access and safetyThe --readonly option is described as safe mode that prevents any write operations to the semantic model; --readwrite is the default with a confirmation prompt. Blocking access requires disabling the XMLA endpoint because no tenant admin setting specifically blocks this server. With only Build permission the server can only run DAX queries; Write permission is needed to change model objects.Tools can be limited with INCLUDE_TOOLS or EXCLUDE_TOOLS environment variables (comma-separated tool or group names). Mutating flow tools (run-flow, run-flow-task, cancel-flow-run) are described as preview-and-confirm tools, and delete-content is admin-only and two-phase. The query-datasource tool is annotated readOnlyHint true and destructiveHint false in source. Telemetry defaults to the noop provider.
What it reachesThe local server connects to semantic models in Power BI Desktop, Fabric workspaces and Power BI Project (PBIP) files; --compatibility Full also targets Analysis Services databases. Hosted uses Streamable HTTP and Entra ID; local uses stdio, with Desktop, PBIP files, transactions and traces only on local.The server works with Tableau Cloud and Tableau Server of any edition, with some tools gated by SKU. Tools span published data sources, workbooks, views, custom views, projects, Prep flows, Pulse metrics, extract refresh tasks, users and Admin Insights. The server speaks stdio by default and HTTP as an alternative transport.
Lineage and impactThe server exposes model-object tools for tables, columns, measures, relationships, partitions, hierarchies, calculation groups and named expressions (model definition level). Database_operations can import and export TMDL folders and deploy to Fabric, giving agents the model definition as code. None found: A lineage tool in the Power BI Authoring MCP tool table (no upstream-table, column-lineage or report-dependency tool).Tableau's get-datasource-metadata tool returns table relationships, field descriptions, roles and types, calculation strings and parameters for a data source (table, column and calculation-definition level, not transformation lineage). The describe-flow tool summarizes a Tableau Prep flow's design including inputs, outputs, steps, lineage and connections, on all SKUs. On Tableau+ only, query-knowledge-context queries governed definitions, relationships, lineage, impact and graph sources through one read-only tool. The server's get-datasource-metadata tool enriches VizQL Data Service results with Tableau's Metadata API and only returns the richer descriptions for published data sources.
Definitions, ownership and rulesTools manage security roles with row-level security, perspectives, cultures and object translations, which are governance and meaning objects inside the model. The server can evaluate a model against a set of modeling practice rules and generate documentation for an existing model.Tableau MCP serves Pulse metric definitions and the Pulse insights engine to agents so metrics are answered from governed definitions. On Tableau+ only, manage-knowledge-context creates, updates or deletes customer-governed semantic context, and inspect-knowledge-context reports graph status and improvement suggestions. The intro page positions the server on reusing curated data models and metadata so agent answers are grounded in pre-built data semantics.
Freshness and upkeepThe server connects to semantic models through the XMLA endpoint, so it reads and writes the live model rather than a collected copy. None found: Scheduled metadata collection or lineage refresh in the Power BI Authoring MCP README or Learn page.Query-datasource runs VizQL Data Service queries against published data sources at call time, so answers reflect live data rather than a collected copy. None found: Any scheduled or event-driven metadata collection in the Tableau MCP docs intro page; the server calls Tableau REST, Metadata and VizQL APIs per request.
ProfileUse of the software is subject to the Power BI Authoring MCP Server EULA, and NPX installs require explicit acceptance. Microsoft advises the hosted server for Fabric workspaces and not registering both local and remote at once.The docs site footer credits Salesforce, Inc. as the copyright holder of Tableau MCP. The package can run via npx (Node 22.7.5 or later), Docker, Heroku, or as Node single-executable binaries; a separate Tableau Desktop authoring server is not in the npm package.

Tool names, as published

Power BI Modeling MCP Server

connection_operations database_operations transaction_operations model_operations table_operations column_operations measure_operations relationship_operations dax_query_operations trace_operations partition_operations user_hierarchy_operations calculation_group_operations security_role_operations perspective_operations named_expression_operations function_operations culture_operations object_translation_operations calendar_operations query_group_operations

Tableau MCP

list-datasources list-workbooks list-projects list-views list-custom-views get-datasource-metadata get-workbook download-workbook get-flow describe-flow get-flow-task list-flows list-flow-runs list-flow-tasks run-flow run-flow-task cancel-flow-run delete-content get-view-data get-view-image get-custom-view-data get-custom-view-image query-datasource list-all-pulse-metric-definitions list-pulse-metric-definitions-from-definition-ids list-pulse-metrics-from-metric-definition-id list-pulse-metrics-from-metric-ids list-pulse-metric-subscriptions generate-pulse-metric-value-insight-bundle generate-pulse-insight-brief search-content list-extract-refresh-tasks update-cloud-extract-refresh-task list-users update-user query-admin-insights query-knowledge-context inspect-knowledge-context manage-knowledge-context scaffold-data-app

Sources

  1. learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp, read 10 Nov 2026
  2. github.com/microsoft/powerbi-modeling-mcp/releases, read 10 Nov 2026
  3. registry.npmjs.org/@microsoft/powerbi-modeling-mcp, read 10 Nov 2026
  4. raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md, read 10 Nov 2026
  5. learn.microsoft.com/en-us/power-bi/developer/mcp/mcp-servers-overview, read 10 Nov 2026
  6. tableau.github.io/tableau-mcp/docs/intro, read 10 Nov 2026
  7. github.com/tableau/tableau-mcp/releases, read 10 Nov 2026
  8. registry.npmjs.org/@tableau/mcp-server, read 10 Nov 2026
  9. raw.githubusercontent.com/tableau/tableau-mcp/main/README.md, read 10 Nov 2026
  10. raw.githubusercontent.com/tableau/tableau-mcp/main/src/tools/web/getDatasourceMetadata/getDatasourceMetadata.ts, read 10 Nov 2026
  11. github.com/tableau/tableau-mcp, read 10 Nov 2026
  12. tableau.github.io/tableau-mcp/docs/configuration/mcp-config/env-vars, read 10 Nov 2026
  13. tableau.github.io/tableau-mcp/docs/configuration/mcp-config/authentication, read 10 Nov 2026
  14. raw.githubusercontent.com/tableau/tableau-mcp/main/src/tools/web/queryDatasource/queryDatasource.ts, read 10 Nov 2026

Last reviewed 10 Nov 2026.