execute_dax_query
Run a DAX query on a Power BI dataset to retrieve and return the results.
Instructions
Execute a DAX query against a Power BI dataset and return results.
Args: dataset_id: The dataset ID to query. dax_query: A valid DAX query string, e.g. "EVALUATE SUMMARIZE(Sales, Sales[Region])". workspace_id: Optional workspace ID that contains the dataset.
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": {
"dataset_id": "<dataset_id>",
"dax_query": "<dax_query>"
},
"name": "execute_dax_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dax_query | Yes | ||
| dataset_id | Yes | ||
| workspace_id | No |