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

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

put
Authorizations
Path parameters
datasetIdstringRequired

Enter ID of an existing dataset

workspaceIdstringRequired

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

Query parameters
versionstringOptional

The requested API version

Default: 1.0
Header parameters
embedfast-user-idstringOptional

Optional User Id

Body

Represents a model for updating a relationship in a Power BI dataset.

toTableNamestring | nullableOptional

The name of the table on the "To" side of the relationship.

newToTableNamestring | nullableOptional

The name of the table on the "To" side of the relationship.

toColumnNamestring | nullableOptional

The name of the column on the "To" side of the relationship.

newToColumnNamestring | nullableOptional

The name of the column on the "To" side of the relationship.

fromTableNamestring | nullableOptional

The name of the table on the "From" side of the relationship.

newFromTableNamestring | nullableOptional

The name of the table on the "From" side of the relationship.

fromColumnNamestring | nullableOptional

The name of the column on the "From" side of the relationship.

newFromColumnNamestring | nullableOptional

The name of the column on the "From" side of the relationship.

fromCardinalitystring | nullableOptional

Specifies the cardinality of the "From" side of the relationship (e.g., one or many).

newFromCardinalitystring | nullableOptional

Specifies the cardinality of the "From" side of the relationship (e.g., one or many).

toCardinalitystring | nullableOptional

Specifies the cardinality of the "To" side of the relationship (e.g., one or many).

newToCardinalitystring | nullableOptional

Specifies the cardinality of the "To" side of the relationship (e.g., one or many).

isActivebooleanOptional

Specifies whether the relationship should be active or inactive.

crossFilterDirectionstring | nullableOptional

Specifies the cross-filter direction (e.g., single or both).

securityFilteringDirectionstring | nullableOptional

Represents the direction of security filtering in the relationship of a Power BI dataset.

Responses
200

Success: The relationship was created or updated successfully.

No content

put
PUT /workspace/{workspaceId}/dataset/{datasetId}/relationship HTTP/1.1
Host: 
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 377

{
  "toTableName": "text",
  "newToTableName": "text",
  "toColumnName": "text",
  "newToColumnName": "text",
  "fromTableName": "text",
  "newFromTableName": "text",
  "fromColumnName": "text",
  "newFromColumnName": "text",
  "fromCardinality": "text",
  "newFromCardinality": "text",
  "toCardinality": "text",
  "newToCardinality": "text",
  "isActive": true,
  "crossFilterDirection": "text",
  "securityFilteringDirection": "text"
}

No content

Last updated