Actions32
- Admin Actions
- Dashboard Actions
- Dataflow Actions
- Dataset Actions
- Gateway Actions
- Group Actions
- Report Actions
Dataset → Execute Queries
AI-generatedSummary
Run a DAX query against a Power BI dataset and return the API response as n8n JSON output. Choose a workspace, or leave it blank to use My Workspace, then select the dataset and provide the required query.
Inputs
- Group (Workspace) Name or ID — Select a workspace or provide its ID. Leave blank to use My Workspace.
- Dataset Name or ID (required) — Select the dataset or provide its ID.
- DAX Query (required) — The DAX query to execute.
- Include Nulls — Include blank values in the result set; defaults to false.
- Impersonated User Name — Optional user principal name to impersonate for row-level security. The value is trimmed before it is sent.
Output shape
One or more JSON items derived from the Power BI API response.
The request submits one query. When Include Nulls is enabled, the request asks Power BI to include blank values; a non-empty impersonated user name is included in the request. No dataset data is modified by this operation.