Edit Semantic Model - Generates a DAX expression for a calculated table based on the provided prompt

Generates a DAX (Data Analysis Expressions) query based on the provided prompt, using Azure OpenAI's GPT model.

post

Authorizations

Bearer

HTTPRequired

Please enter a valid token

Path parameters

workspaceIdstringRequired

datasetIdstringRequired

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 generate a DAX query from a user prompt.

inputPromptstring · nullableOptional

The user-provided prompt to generate the DAX query.

interactionTypestring · nullableOptional

The type of interaction or context for generating the query, such as 'generate' or 'validate'.

userPromptstring · nullableOptional

The user prompt.

objectNamestring · nullableOptional

The name of the object being generated.

sourceTableNamestring · nullableOptional

The table name for measures and columns

Responses

200

Success: The DAX query was successfully generated based on the provided prompt.

text/plainapplication/jsontext/json

Represents the response of a DAX generation or validation operation.

successbooleanOptional

Indicates whether the operation was successful.

messagestring · nullableOptional

A message providing additional information about the operation's result.

daxQuerystring · nullableOptional

The DAX query generated or validated.

recommendationsstring · nullableOptional

The DAX query enhancements or correction recommendations.

400

Bad Request: The server cannot process the request due to client errors, such as malformed syntax or invalid input.

text/plainapplication/jsontext/json

401

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

text/plainapplication/jsontext/json

500

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

text/plainapplication/jsontext/json

post

/workspace/{workspaceId}/dataset/{datasetId}/table/generateDax

HTTPcURLJavaScriptPython

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

{
  "inputPrompt": "text",
  "interactionType": "text",
  "userPrompt": "text",
  "objectName": "text",
  "sourceTableName": "text"
}

application/jsontext/jsonapplication/*+json

{
  "success": true,
  "message": "text",
  "daxQuery": "text",
  "recommendations": "text"
}