Generate DAX - Executes a DAX query against a specified Power BI dataset

Executes a DAX query against a specified Power BI dataset.

post

Authorizations

Path parameters

workspaceIdstringRequired

Enter ID of the workspace for which the DAX query is executed.

datasetIdstringRequired

Enter ID of an existing dataset

Query parameters

versionstringOptional

The requested API version

Default: 1.0

Body

application/jsonapplication/*+jsontext/json

Request model for DAX execution operations.

daxQuerystringRequired

A public property of type string that contains the DAX query to execute.

Responses

200

Success: The DAX query was executed successfully, and the result is returned.

application/json

400

Bad Request: The server cannot process the request due to a client error, such as malformed syntax or invalid query parameters.

application/jsontext/plaintext/json

401

Unauthorized: The request lacks valid authentication credentials for the target resource.

application/jsontext/plaintext/json

500

Internal Server Error: An unexpected server error occurred while processing the request.

application/jsontext/plaintext/json

post

HTTPcURLJavaScriptPython

POST /workspace/{workspaceId}/dataset/{datasetId}/executeDax HTTP/1.1
Host: 
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 19

{
  "daxQuery": "text"
}

application/jsonapplication/*+jsontext/json

{
  "success": true,
  "message": "text",
  "result": "text"
}