Power BI Report MCP Server

60 tools. 43 can modify or destroy data without limits.

9 destructive tools with no built-in limits. Policy required.

Last updated:

43 can modify or destroy data
17 read-only
60 tools total

Community server · catalogue entry verified 29/06/2026

How to control Power BI Report MCP Server ↓

What Power BI Report MCP Server exposes to your agents

Read (17) Write / Execute (33) Destructive / Financial (9)
Critical Risk

The most dangerous Power BI Report MCP Server tools

43 of Power BI Report MCP Server's 60 tools can modify, destroy, or commit something on every call — and an agent calls them with no built-in limits.

How to control Power BI Report MCP Server

PolicyLayer is an MCP gateway — it sits between your AI agents and Power BI Report MCP Server, and nothing reaches the server without passing your rules. These are the rules we recommend:

Deny destructive operations
{
  "pbir_bulk_delete_visuals": {
    "deny_if": [
      {
        "conditions": [],
        "on_deny": "Blocked by default. Requires approval."
      }
    ]
  }
}

Destructive tools should never be available to autonomous agents without human approval.

Rate limit write operations
{
  "pbir_add_bookmark": {
    "limits": [
      {
        "counter": "pbir_add_bookmark_per_hour",
        "window": "hour",
        "max": 30,
        "scope": "grant"
      }
    ]
  }
}

Prevents bulk unintended modifications from agents caught in loops.

Cap read operations
{
  "pbir_audit_theme_compliance": {
    "limits": [
      {
        "counter": "pbir_audit_theme_compliance_per_minute",
        "window": "minute",
        "max": 60,
        "scope": "grant"
      }
    ]
  }
}

Controls API costs and prevents retry loops from exhausting upstream rate limits.

  1. Create a free account and register Power BI Report MCP Server — nothing to install.
  2. Add these rules — paste them, or build them visually. Tune the limits to your setup.
  3. Point your MCP client (Claude, Cursor, anything) at your gateway URL.
ENFORCE POLICY ON POWER BI REPORT →

Instant setup, no code required.

All 60 Power BI Report MCP Server tools

WRITE 33 tools
Write pbir_add_bookmark Create a new bookmark. The bookmark is created with an empty exploration state — open Power BI Desktop to capt Write pbir_add_page_filter Add a filter to a page or visual. Omit visualId for page-level. topN requires visualId. Types: categorical / t Write pbir_add_visual Add visuals to a page via Write pbir_add_visual_calculation Add a DAX visual calculation to a matrix or table visual. Examples: RUNNINGSUM([Sales]), RANK(), MOVINGAVERAGE Write pbir_apply_theme Apply a named theme preset to all visuals on a page. Themes: ${Object.keys(THEME_PRESETS).join( Write pbir_auto_layout Auto-arrange all visuals on a page in a grid. Write pbir_bulk_bind Rebind multiple visuals in one call. Replaces existing bindings. Set confirmBulk:true when >5. continueOnError Write pbir_bulk_update_format Apply the same formatting to multiple visuals. target= Write pbir_change_visual_type Change the visual type of an existing visual (e.g. barChart to columnChart) while keeping data bindings Write pbir_create_page Create a new page in the report. Supports standard, tooltip, and drillthrough page types. Write pbir_duplicate_page Duplicate an entire page with all its visuals to a new page Write pbir_duplicate_visual Duplicate an existing visual, optionally to a different page or position Write pbir_format_visual Format visual properties. Auto-routes title/background/border/padding/dropShadow/visualHeader to container, ot Write pbir_layout_grid Compute a deterministic rows×cols grid; server owns margin/gap/remainder math. Use this INSTEAD of N pbir_add_ Write pbir_move_visual Move and/or resize a visual on a page Write pbir_remove_report_theme Remove the custom theme from the report, reverting to the default base theme. The theme file is kept in Static Write pbir_rename_bookmark Rename an existing bookmark. Write pbir_rename_page Rename an existing page Write pbir_reorder_pages Set the page order Write pbir_set_active_page Set which page is active (shown on open) Write pbir_set_conditional_format Apply conditional formatting to a visual container background or title font. formatType: rules / gradient / cl Write pbir_set_datapoint_colors Set data point colors. Series-based charts use metadata mode. Category-based (no Series) requires categoryEnti Write pbir_set_filter_pane Show or hide the filter pane. Write pbir_set_page_background Set the page canvas background and/or wallpaper. Hex color (0D1117). Transparency 0-100. Write pbir_set_page_visibility Show or hide a page in the navigation pane. Hidden pages still work for drillthrough. Write pbir_set_report Connect to a different Power BI report (.Report folder or parent .pbip project folder). Use this to switch rep Write pbir_set_report_theme Apply a custom JSON theme. Hex colors. dataColors 6-12 values. visualStyles keyed by visualType or Write pbir_set_visual_interaction Set cross-filter interaction (Filter/Highlight/NoFilter) from source visual to target visual. Write pbir_set_visual_sort Set the sort order of a visual. Overrides the auto-sort. Use Table[Column] for field refs. Write pbir_set_visual_title Set or update the title of a visual. Can set text, visibility, font, size, alignment. Write pbir_update_page_size Update the page dimensions Write pbir_update_report_settings Merge report-level settings. Keys: useStylableVisualContainerHeader, useEnhancedTooltips, exportDataMode (0|1) Write pbir_update_visual_bindings Update the data bindings of an existing visual. Replaces the query state entirely. Supports Table[Column] shor
READ 17 tools
Read pbir_audit_theme_compliance Audit visuals on a page for theme overrides. Returns summary header + topN findings (default 20). topN:0 = all Read pbir_diff_report_theme Compare a proposed theme JSON against the currently applied theme and return what would be added, removed, or Read pbir_get_report Show the currently connected report path. Includes Read pbir_get_report_settings Get the report-level settings and theme configuration Read pbir_get_report_theme Get the currently applied theme. Returns base theme name + custom theme JSON if any. Read pbir_get_visual Get visual details. Default returns id/type/position/title/bindings summary. verbose:true returns full PBIR JS Read pbir_get_visual_types List available visual types. Default returns slim type list (~150 tokens). Pass verbose:true for per-type data Read pbir_guide Domain knowledge for Power BI report development. Topics discovered live from skills/.md — call with topic: Read pbir_list_bookmarks List all bookmarks defined in the report. Read pbir_list_filters List filters on a page or visual. Slim mode (default) returns Table[Column] strings. Read pbir_list_pages List pages (paginated). Slim default returns id/displayName/width/height/visualCount/isActive/hidden; slim:fal Read pbir_list_report_themes List all theme files stored in the report Read pbir_list_visual_calculations List all visual calculations on a visual. Visual calculations are DAX expressions scoped to the visual context Read pbir_list_visuals List visuals on a page (paginated). Default slim returns id/type/x/y/w/h/title. slim:false includes filterCoun Read pbir_lookup_theme_property Query the bundled Power BI theme schema for valid visualStyles property names. No args = list visual types; +v Read pbir_model_usage Cross-reference the semantic model with the report — shows where every measure and column is used, DAX depende Read pbir_validate_wireframe Validate a page
OTHER 1 tools

Related servers

Other MCP servers with similar tools — same risk classification, starter policies for each.

Questions about Power BI Report MCP Server

Can an AI agent delete data through the Power BI Report MCP Server MCP server? +

Yes. The Power BI Report MCP Server server exposes 9 destructive tools including pbir_bulk_delete_visuals, pbir_clear_filters, pbir_delete_bookmark. These permanently remove resources with no undo. PolicyLayer blocks destructive tools by default so they never reach the upstream server.

How do I prevent bulk modifications through Power BI Report MCP Server? +

The Power BI Report MCP Server server has 33 write tools including pbir_add_bookmark, pbir_add_page_filter, pbir_add_visual. Set a rate limit in your policy -- for example, 10 calls per hour prevents an agent from making more than 10 modifications per hour. PolicyLayer enforces this at the gateway, before calls reach Power BI Report MCP Server.

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

60 tools across 3 categories: Destructive, Read, Write. 17 are read-only. 43 can modify, create, or delete data.

How do I enforce a policy on Power BI Report MCP Server? +

Register the Power BI Report MCP Server MCP server in PolicyLayer, apply the suggested rules above (adjust the limits to your use case), and point your AI client at the PolicyLayer proxy URL instead of the server directly. Your agents keep the same tools; PolicyLayer evaluates every call against policy before it executes. Nothing to install, live in minutes.

Enforce policy on every Power BI Report MCP Server tool call.

Deterministic rules across all 60 Power BI Report MCP Server tools. Per-identity grants. Full audit log. Live in minutes. Nothing to install.

Instant setup, no code required.

60 Power BI Report MCP Server tools catalogued and risk-classified — across an index of 43,000+ MCP servers.

// GET IN TOUCH

Have a question or want to learn more? Send us a message.

Message sent.

We'll get back to you soon.