update_table_sql
Replace a specific SQL line or block inside a Power BI table’s Value.NativeQuery expression. Preview the proposed change with dry-run, then write and validate the update.
Instructions
Surgically replace a line or block inside a table's Value.NativeQuery SQL expression.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"old_text": "<old_text>",
"new_text": "<new_text>"
},
"name": "update_table_sql"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dry_run | No | When true, return the proposed ChangePlan without modifying files. Defaults to true. Set false to execute the write with post-write validation. | |
| new_text | Yes | Replacement SQL line or block. | |
| old_text | Yes | Exact SQL line or block to replace. | |
| partition | No | Optional partition name. | |
| workspace | No | Workspace identifier returned by list_workspaces (prefer workspace_id or unique name). Optional when the server is bound to a single workspace. | |
| table_name | No | Table name containing the SQL partition. | |
| expected_replacements | No | Optional guard requiring an exact number of matches. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||