Generate DAX - Adds a calculated column in a specified table within a Power BI dataset

Adds a calculated column in a specified table within a Power BI dataset.

post

Authorizations

Path parameters

workspaceIdstringRequired

Enter ID of the workspace for which the calculated column is added.

datasetIdstringRequired

Enter ID of an existing dataset

Query parameters

versionstringOptional

The requested API version

Default: 1.0

Body

application/jsonapplication/*+jsontext/json

Model for creating or updating calculated columns.

tableNamestringRequired

A public property of type string that specifies the table where the calculated column will be created.

calculatedColumnNamestringRequired

A public property of type string that specifies the name of the calculated column.

calculatedColumnExpressionstringRequired

A public property of type string that contains the DAX expression for the calculated column.

Responses

200

Success: The calculated column was added successfully.

application/json

400

Bad Request: The server cannot process the request due to a client error, such as malformed syntax or invalid table/column details.

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}/addColumn HTTP/1.1
Host: 
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 86

{
  "tableName": "text",
  "calculatedColumnName": "text",
  "calculatedColumnExpression": "text"
}

application/jsonapplication/*+jsontext/json

{
  "message": "text"
}