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.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| model | No | ||
| dax_query | Yes | ||
| workspace | No | ||
| include_execution_plan | No |