Edit Semantic Model - Executes a DAX query against a specified Power BI dataset

Executes a DAX query against a specified Power BI dataset.

post

Authorizations

Bearer

HTTPRequired

Please enter a valid token

Path parameters

workspaceIdstringRequired

Enter ID of the workspace for which the theme details are requested.

datasetIdstringRequired

Enter ID of an existing dataset

Query parameters

versionstringOptional

The requested API version

Default: 1.0

Header parameters

embedfast-user-idstringOptional

Optional User Id

Body

application/jsontext/jsonapplication/*+json

Represents the request to execute a DAX query against a Power BI dataset.

daxQuerystring · nullableOptional

The DAX query to be executed.

interactionTypestring · nullableOptional

The type of interaction (e.g., "validate").

objectNamestring · nullableOptional

The name of the object being validated.

userPromptstring · nullableOptional

The user prompt associated with the query.

tableNamestring · nullableOptional

The table name associated with the query.

objectTypestring · nullableOptional

The type of object (e.g., "measure", "column", "table").

Responses

200

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

text/plainapplication/jsontext/json

Represents the response of a DAX execution operation.

successbooleanOptional

Indicates whether the execution operation was successful.

messagestring · nullableOptional

A message providing additional details or error information about the execution result.

resultstring · nullableOptional

The result or output of the executed DAX query.

400

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

text/plainapplication/jsontext/json

401

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

text/plainapplication/jsontext/json

403

Forbidden: Access to the resource is denied, often due to insufficient permissions.

500

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

text/plainapplication/jsontext/json

post

/workspace/{workspaceId}/dataset/{datasetId}/executeDax

HTTPcURLJavaScriptPython

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

{
  "daxQuery": "text",
  "interactionType": "text",
  "objectName": "text",
  "userPrompt": "text",
  "tableName": "text",
  "objectType": "text"
}

application/jsontext/jsonapplication/*+json

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