execute_service_query
Run DAX queries against published Power BI datasets via REST, bypassing Desktop and live model sessions. Authentication uses an AAD token with Power BI scopes.
Instructions
Run a DAX query against a PUBLISHED dataset over REST (POST .../executeQueries) - no Desktop, no live model session. Needs an AAD access token with the Power BI scopes (accessToken param or DAXOPS_PBI_TOKEN); never echoed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dax | Yes | the DAX query, e.g. EVALUATE TOPN(10, 'Sales') | |
| datasetId | Yes | dataset id | |
| accessToken | No | AAD access token with Power BI scopes; omit to use DAXOPS_PBI_TOKEN | |
| workspaceId | Yes | workspace (group) id |