Edit Semantic Model - Adds a relationship between two tables in a Power BI dataset within a specific

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 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

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 or updated successfully.

400

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

401

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

500

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

post

POST /workspace/{workspaceId}/dataset/{datasetId}/relationship HTTP/1.1
Host: admin-embedfastdev-app.azurewebsites.net
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"
}

No content

PreviousEdit Semantic Model - Deletes a column from a specified table within a Power BI dataset NextEdit Semantic Model - Updates a relationship between two tables in a Power BI dataset within a speci

Last updated 13 hours ago