analyze_dax_query
Analyze DAX queries to identify performance bottlenecks by returning execution time, scan counts, and detailed execution plans.
Instructions
Analyze a DAX query for performance insights and execution plan.
This tool executes a DAX query and returns performance metrics including
execution time, scan counts, and optionally the query execution plan.
Args:
dax_query: DAX query to analyze
workspace: Name or ID of the workspace (optional)
model: Name or ID of the semantic model (optional)
include_execution_plan: Whether to include detailed execution plan (default: True)
ctx: Context object containing client information
Returns:
A dictionary containing query results, execution metrics, and optionally the execution plan.
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": {
"dax_query": "<dax_query>"
},
"name": "analyze_dax_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| model | No | ||
| dax_query | Yes | ||
| workspace | No | ||
| include_execution_plan | No |