Table.ReplaceRelationshipIdentity

TableInternal

Replaces the relationship identity on a value. Intended for internal use only.

Syntax

Table.ReplaceRelationshipIdentity(value as any, identity as text) as any

Parameters

Name	Type	Required	Description
`value`	`any`	Yes	The value whose relationship identity to replace.
`identity`	`text`	Yes	The new relationship identity text to assign.

Return Value

any — The value with the relationship identity replaced.

Remarks

This function is intended for internal use only. It is part of the Power Query engine's infrastructure for managing relationship metadata between tables — for example, the foreign key relationships used in Power BI data models. Its behavior may change without notice between Power Query versions.

For working with table relationships in user-authored queries, use Tables.GetRelationships to discover relationships and Table.NestedJoin or Table.Join to combine related tables.

Examples

Example 1: Recommended alternative — use Table.NestedJoin

let
    Joined = Table.NestedJoin(
        Sales, {"CustomerID"},
        Customers, {"CustomerID"},
        "CustomerDetails",
        JoinKind.LeftOuter
    )
in
    Joined

Compatibility

✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks