Table.ReplaceKeys

Updated on

Table.ReplaceKeys is a Power Query M function that replaces the keys of a specified table. The function returns a new table with the keys replaced.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Table.ReplaceKeys(
   table as table,
   keys as list,
) as table

Description

Table.ReplaceKeys replaces the keys of the specified table, allowing you to update the primary identifiers for the table’s rows.

Examples

Replace the existing keys of a table.

let
    table = Table.FromRecords( {
        [Id = 1, Name = "Hello There"],
        [Id = 2, Name = "Good Bye"]
    } ),
    tableWithKeys = Table.AddKey( table, {"Id"}, true ),
    resultTable = Table.ReplaceKeys( tableWithKeys, {[Columns = {"Id"}, Primary = false]} )
in
    resultTable

 /* Output: 
Table.FromRecords( {
    [Id = 1, Name = "Hello There"],
    [Id = 2, Name = "Good Bye"]
} )
 */ 

Other functions related to Table.ReplaceKeys are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/table-replacekeys