Execute DAX query and build HTML dashboard
execute_dax_dashboard_queryExecute a DAX query to retrieve data for a Power BI dashboard based on a business question. Returns results for integration with report generation.
Instructions
Alias for execute_dax_report_query kept for compatibility with earlier dashboard workflows.
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": {
"question": "<question>",
"query": "<query>"
},
"name": "execute_dax_dashboard_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | DAX query text, for example EVALUATE ROW("Revenue", SUM(Visits[TreatmentCost])). | |
| title | No | Optional dashboard title. Defaults to the question. | |
| maxRows | No | ||
| question | Yes | The business question from the executive user. | |
| workspaceName | No | Power BI workspace name. Defaults to POWERBI_DEFAULT_WORKSPACE. | |
| timeoutSeconds | No | ||
| semanticModelName | No | Semantic model name. Defaults to POWERBI_DEFAULT_SEMANTIC_MODEL. |