POWER BI MCP SERVER TOOLS

70 tools from the Power BI MCP Server MCP Server, categorised by risk level.

// ALL 70 POWER BI MCP SERVER TOOLS

READ 43 tools

Read impact_analysis Blast radius before a change: lists model objects that depend on a measure/column (INFO.CALCDEPENDENCY) and... Read model_diff Produce a human-readable semantic diff (added/removed/changed tables, columns, measures, relationships) bet... Read run_bpa Run a Best Practice Analyzer over the connected semantic model (performance, DAX, naming, formatting, maint... Read analyze_model_storage VertiPaq-style storage analysis: per-table row counts (exact via DAX COUNTROWS), column counts, and best-ef... Read audit_ai_readiness Score how AI-ready (Copilot/agent-ready) the model is: coverage of descriptions and format strings on measu... Read audit_naming Audit naming conventions across the connected model Read bpa_audit_rule_sources Audit where BPA rules live for the loaded PBIP project: rules embedded in the model (BestPracticeAnalyzer a... Read bpa_validate_rules Validate a custom Best Practice Analyzer rules JSON (the public BPA rule shape): required fields (ID/Name/C... Read cross_workspace_lineage Tenant-wide inventory + lineage via the Admin Scanner API: workspace/dataset/report counts, datasets missin... Read dax_lint Static-analyze DAX for performance anti-patterns and correctness traps (FILTER over a whole table in CALCUL... Read dax_suggest_rewrite For the auto-fixable DAX anti-patterns (bare Read desktop_discover_instances Discover all running Power BI Desktop instances on this machine Read desktop_get_model_info Get comprehensive model info (tables, columns, measures, relationships) from Power BI Desktop Read desktop_list_columns List columns for a table in the connected Power BI Desktop model Read desktop_list_measures List all measures in the connected Power BI Desktop model Read desktop_list_rls_roles List all RLS (Row-Level Security) roles defined in the Power BI Desktop model Read desktop_list_tables List all tables in the connected Power BI Desktop model Read desktop_rls_status Get the current RLS status including active role and available roles Read find_unused_objects Find columns and measures not referenced by any other model object (INFO.CALCDEPENDENCY), relationship, or ... Read fleet_refresh_monitor Refresh health across many datasets: for each refreshable dataset in the given workspaces, check the most r... Read get_model_info Get comprehensive model info from a Power BI Service dataset using INFO.VIEW functions Read list_columns List columns for a table in a Power BI Service dataset Read list_datasets List all datasets in a Power BI Service workspace Read list_tables List all tables in a Power BI Service dataset via XMLA Read list_workspaces List all Power BI Service workspaces accessible to the Service Principal Read model_snapshot Capture the connected model Read pbip_get_project_info Get information about the loaded PBIP project including paths to TMDL files and report.json Read pbip_load_project Load a PBIP (Power BI Project) for file-based editing. PBIP format allows safe bulk renames without breakin... Read pbip_scan_broken_refs Scan the PBIP project for broken references. Compares table names in semantic model vs report visuals to fi... Read pbip_validate Validate TMDL syntax in the loaded PBIP project. Checks for unquoted names with spaces, invalid references,... Read pbir_validate_report [PREVIEW] Validate that every field referenced by the report Read pbix_extract Extract a .pbix package to a folder (Zip-Slip protected). Also decodes the legacy UTF-16-LE Report/Layout i... Read pbix_inspect Inspect a .pbix file (an OPC ZIP package) without extracting: classify it as thick (imported model) vs thin... Read refresh_doctor Diagnose a dataset Read rls_test_harness Evaluate a measure or table row count under EVERY RLS role and return a pass/fail matrix vs the unrestricte... Read scan_measure_dependencies Analyze the dependency graph of a measure or column using INFO.CALCDEPENDENCY: upstream (what it depends on... Read scan_table_dependencies Scan a table to find all references before renaming. Shows measures, calculated columns, and relationships ... Read security_audit_log View recent entries from the security audit log Read security_status Get the current security settings and status (PII detection, audit logging, access policies) Read usage_and_orphan_analytics Tenant usage analytics from the Admin Activity Events API for one UTC day: total events, distinct users, to... Read validate_dax Validate a DAX query or scalar measure expression against the connected model WITHOUT committing anything. ... Read verify_audit_integrity Verify the audit-log hash chain (compliance/forensics). Detects edited, inserted, deleted, or hash-stripped... Read export_data_dictionary Generate a portable data dictionary (tables, columns, measures with DAX, relationships) for the connected m...

WRITE 17 tools

Write pbip_fix_broken_visuals Fix broken visual references after a table rename. Use this when TOM/API renamed a table but visuals still ... Write pbip_fix_dax_quoting Fix all DAX expressions by properly quoting table names with spaces. Fixes: Leads Sales Data[Amount] -> Write tom_rollback_transaction Roll back (UndoLocalChanges) all pending TOM model edits made since tom_begin_transaction and close the tra... Write batch_rename_columns ⚠️ DEPRECATED: Use Write batch_rename_measures ⚠️ DEPRECATED: Use Write batch_rename_tables ⚠️ DEPRECATED: Use Write batch_update_measures Bulk update multiple measure expressions in the Power BI Desktop model. Write create_measure Create a new DAX measure in the Power BI Desktop model. Write create_relationship Create a relationship between two columns in the connected Power BI Desktop model (TOM). Honors an open tom... Write generate_svg_measure Generate a ready-to-use DAX measure that returns an inline SVG micro-visual (progress bar, bullet chart, st... Write pbip_rename_columns ✅ RECOMMENDED: Safely rename columns in a PBIP project. Updates TMDL files, DAX references, and report visu... Write pbip_rename_measures ✅ RECOMMENDED: Safely rename measures in a PBIP project. Updates TMDL files, DAX references, and report vis... Write pbip_rename_tables ✅ RECOMMENDED: Safely rename tables in a PBIP project. Updates EVERYTHING: TMDL files, DAX references (with... Write pbir_add_page [PREVIEW] Add a new report page to the loaded PBIR-Enhanced PBIP project. Writes a schema-valid page.json a... Write pbir_add_visual [PREVIEW] Add a visual to a page in the loaded PBIR-Enhanced project. Supported visual_type: card, kpi, tab... Write pbir_bind_fields [PREVIEW] Add or replace field bindings on an existing visual without recreating it. mode Write tom_commit_transaction Commit (SaveChanges) all pending TOM model edits made since tom_begin_transaction and close the transaction.

DESTRUCTIVE 2 tools

Destructive delete_measure Delete a measure from the Power BI Desktop model. Destructive delete_relationship Delete a relationship in the connected Power BI Desktop model (TOM), identified by name or by from/to table...

EXECUTE 8 tools

Execute desktop_execute_dax Execute a DAX query against the connected Power BI Desktop model Execute execute_dax Execute a DAX query against a Power BI Service dataset Execute pre_deploy_gate CI/pre-deploy quality gate: runs the Best Practice Analyzer and AI-readiness audit and returns a machine PA... Execute run_dax_tests Run a suite of DAX regression tests against the model: each test is {name, dax, expected, tolerance?}; retu... Execute analyze_query_performance Execute a DAX query and report duration, row count, and heuristic optimization hints. For storage-engine vs... Execute desktop_connect Connect to a Power BI Desktop instance by port number. Optionally specify an RLS role to test. Execute desktop_set_rls_role Set or clear the active RLS role for testing. When set, all queries will be filtered by that role Execute tom_begin_transaction Begin a TOM write transaction. While open, model write tools (create_measure, delete_measure, batch_update_...

// FAQ

How many tools does the Power BI MCP Server MCP server have? +

The Power BI MCP Server MCP server exposes 70 tools across 4 categories: Read, Write, Destructive, Execute.

How do I enforce policies on Power BI MCP Server tools? +

Route the Power BI MCP Server server through the PolicyLayer gateway. Define allow, deny, or approval rules per tool in the dashboard; they are enforced on every call before it reaches the server.

What risk categories do Power BI MCP Server tools fall into? +

Power BI MCP Server tools are categorised as Read (43), Write (17), Destructive (2), Execute (8). Each category has a recommended default policy.

Enforce policy on every Power BI MCP Server tool call.

Start from Power BI MCP Server, add the rest of your stack, and see everything your agents can call. Then put policy on all of it.

CHECK YOUR STACK →

Instant setup, no code required.

43,000+ MCP servers and 220,000+ tools scanned and risk-classified.