Execute DAX query with CEO defaults
execute_dax_queryExecute DAX queries against Power BI semantic models. Optionally specify workspace and model; defaults keep the connection alive to reduce login prompts.
Instructions
Execute a DAX query against a Power BI semantic model using default workspace/model when omitted. This keeps the Microsoft Modeling MCP process alive to reduce repeated login prompts.
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": {
"query": "<query>"
},
"name": "execute_dax_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | DAX query text, for example EVALUATE ROW("Revenue", SUM(Visits[TreatmentCost])). | |
| maxRows | No | ||
| workspaceName | No | Power BI workspace name. Defaults to POWERBI_DEFAULT_WORKSPACE. | |
| timeoutSeconds | No | ||
| semanticModelName | No | Semantic model name. Defaults to POWERBI_DEFAULT_SEMANTIC_MODEL. |