Generate DAX - Adds a relationship between two tables in a Power BI dataset within a specific workspace

Adds a relationship between two tables in a Power BI dataset within a specific workspace.

post

Authorizations

Path parameters

workspaceIdstringRequired

Enter ID of the workspace for which the relationship 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 relationships between tables.

fromTableNamestringRequired

A public property of type string that specifies the name of the 'from' table in the relationship.

fromColumnNamestringRequired

A public property of type string that specifies the name of the 'from' column in the relationship.

toTableNamestringRequired

A public property of type string that specifies the name of the 'to' table in the relationship.

toColumnNamestringRequired

A public property of type string that specifies the name of the 'to' column in the relationship.

fromCardinalitystring · enumOptional

A public property of type string that specifies the cardinality of the 'from' side of the relationship.

Default: ManyPossible values:

toCardinalitystring · enumOptional

A public property of type string that specifies the cardinality of the 'to' side of the relationship.

Default: OnePossible values:

isActivebooleanOptional

A public property of type boolean that specifies whether the relationship is active.

Default: true

crossFilterDirectionstring · enumOptional

A public property of type string that specifies the cross-filter direction of the relationship.

Default: SinglePossible values:

securityFilteringDirectionstring · enumOptional

A public property of type string that specifies the security filtering direction of the relationship.

Default: SinglePossible values:

Responses

200

Success: The relationship was created 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}/addRelationship HTTP/1.1
Host: 
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 224

{
  "fromTableName": "text",
  "fromColumnName": "text",
  "toTableName": "text",
  "toColumnName": "text",
  "fromCardinality": "Many",
  "toCardinality": "One",
  "isActive": true,
  "crossFilterDirection": "Single",
  "securityFilteringDirection": "Single"
}

application/jsonapplication/*+jsontext/json

{
  "message": "text"
}