pbir_add_visual_calculation

Add a DAX visual calculation to a matrix or table visual. Examples: RUNNINGSUM([Sales]), RANK(), MOVINGAVERAGE([Value],3), PERCENTOFGRANDTOTAL([Value]), [Value]-PREVIOUS([Value]).

Server Power BI Report MCP Server jonathan-pap/powerbi-report-mcp
Category Write
Risk class Medium
Parameters 00 required

What pbir_add_visual_calculation does on Power BI Report MCP Server

AI agents use pbir_add_visual_calculation to create or update resources in Power BI Report MCP Server — usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Power BI Report MCP Server environment.

Why pbir_add_visual_calculation needs a policy

This tool creates and modifies report content (DAX calculations) reversibly within Power BI reports. It does not delete data, execute arbitrary code outside the DAX context, or cause financial impact. While it modifies the report, changes can be undone (typical for design tools), placing it in Write rather than Execute.

From the tool's definition Tool adds a DAX visual calculation to matrix or table visuals, modifying report structure and behavior. Description explicitly states 'Add' operation that persists calculations to the PBIR file format.

Questions about pbir_add_visual_calculation

What does the pbir_add_visual_calculation tool do? +

Add a DAX visual calculation to a matrix or table visual. Examples: RUNNINGSUM([Sales]), RANK(), MOVINGAVERAGE([Value],3), PERCENTOFGRANDTOTAL([Value]), [Value]-PREVIOUS([Value]). It is categorised as a Write tool in the Power BI Report MCP Server MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

How do I enforce a policy on pbir_add_visual_calculation? +

Register the Power BI Report MCP Server MCP server in PolicyLayer and add a rule for pbir_add_visual_calculation: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches Power BI Report MCP Server. Nothing to install.

What risk level is pbir_add_visual_calculation? +

pbir_add_visual_calculation is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Can I rate-limit pbir_add_visual_calculation? +

Yes. Add a rate_limit block to the pbir_add_visual_calculation rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block pbir_add_visual_calculation completely? +

Set action: deny in the PolicyLayer policy for pbir_add_visual_calculation. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides pbir_add_visual_calculation? +

pbir_add_visual_calculation is provided by the Power BI Report MCP Server MCP server (jonathan-pap/powerbi-report-mcp). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

// LOOK UP ANOTHER SERVER

Every MCP server has a record like this.

Type a name, get the same breakdown: verified identity, auth posture, risk grade, capabilities, recommended policy.

Teams ship this data inside their own products. See what a licence covers →

// GET IN TOUCH

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

Message sent.

We'll get back to you soon.