update_relationship
Update Power BI relationship properties: cardinality, filtering behavior, active flag, and join-on-date logic. Find by name or column pair.
Instructions
Update an existing relationship's cardinality, filtering behaviour, active flag or join-on-date behaviour. Identify it by name, or by all four of fromTable/fromColumn/toTable/toColumn (order-insensitive). fromCardinality/toCardinality = One | Many (to switch 1:1 / M:1 / 1:M / M:M). crossFilteringBehavior = OneDirection | BothDirections | Automatic. securityFilteringBehavior = OneDirection | BothDirections | None. joinOnDateBehavior = DateAndTime | DatePartOnly. Any omitted property is left unchanged.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | relationship name (omit to identify by the column pair) | |
| toTable | No | to-side table | |
| isActive | No | set active/inactive | |
| toColumn | No | to-side column | |
| fromTable | No | from-side table (with the other three for column-pair lookup) | |
| sessionId | Yes | ||
| fromColumn | No | from-side column | |
| toCardinality | No | to-side cardinality: One | Many | |
| fromCardinality | No | from-side cardinality: One | Many | |
| joinOnDateBehavior | No | DateAndTime | DatePartOnly | |
| crossFilteringBehavior | No | OneDirection | BothDirections | Automatic | |
| securityFilteringBehavior | No | OneDirection | BothDirections | None |