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.
Enter ID of an existing dataset
Enter ID of the workspace for which the theme details are requested.
The requested API version
1.0
Optional User Id
Represents a model for updating a relationship in a Power BI dataset.
The name of the table on the "To" side of the relationship.
The name of the table on the "To" side of the relationship.
The name of the column on the "To" side of the relationship.
The name of the column on the "To" side of the relationship.
The name of the table on the "From" side of the relationship.
The name of the table on the "From" side of the relationship.
The name of the column on the "From" side of the relationship.
The name of the column on the "From" side of the relationship.
Specifies the cardinality of the "From" side of the relationship (e.g., one or many).
Specifies the cardinality of the "From" side of the relationship (e.g., one or many).
Specifies the cardinality of the "To" side of the relationship (e.g., one or many).
Specifies the cardinality of the "To" side of the relationship (e.g., one or many).
Specifies whether the relationship should be active or inactive.
Specifies the cross-filter direction (e.g., single or both).
Represents the direction of security filtering in the relationship of a Power BI dataset.
Success: The relationship was created or updated successfully.
No content
Bad Request: The server cannot process the request due to a client error, such as malformed syntax or invalid table/column details.
Unauthorized: The request lacks valid authentication credentials for the target resource.
Internal Server Error: An unexpected server error occurred while processing the request.
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