Edit Semantic Model - Adds a relationship between two tables in a Power BI dataset within a specific workspace
Enter ID of the workspace for which the theme details are requested.
Enter ID of an existing dataset
The requested API version
1.0Optional User Id
Represents a model for defining a relationship between tables in a Power BI dataset.
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 table 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 "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 a Power BI dataset relationship.
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.
POST /workspace/{workspaceId}/dataset/{datasetId}/relationship HTTP/1.1
Host:
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 221
{
"toTableName": "text",
"toColumnName": "text",
"fromTableName": "text",
"fromColumnName": "text",
"fromCardinality": "text",
"toCardinality": "text",
"isActive": true,
"crossFilterDirection": "text",
"securityFilteringDirection": "text"
}No content
Last updated