Execute DAX query and build HTML executive report
execute_dax_report_queryExecute a DAX query to answer business questions and generate an executive HTML dashboard from Power BI data.
Instructions
Execute a DAX query against a Power BI semantic model and return both a concise text answer and a self-contained HTML dashboard/report for executive review. Prefer this tool for boss/CEO business questions.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | DAX query text, for example EVALUATE ROW("Revenue", SUM(Visits[TreatmentCost])). | |
| title | No | Optional report 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. |