Table.Keys

Table.Keys is a Power Query M function that retrieves the keys of a specified table. The function returns a list of the table’s keys.

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

Syntax

Table.Keys( table as table ) as list

Description

Returns the keys of the specified table.

Examples

Get the list of keys for a table.

// Output: {[Columns = {"Id"}, Primary = true]}
let
    table = Table.FromRecords( {
        [Id = 1, Name = "Hello There"],
        [Id = 2, Name = "Good Bye"]
    } ),
    tableWithKeys = Table.AddKey( table, {"Id"}, true ),
    keys = Table.Keys( tableWithKeys )
in
    keys

Related functions

Other functions related to Table.Keys are:

• Table.AddKey
• Table.ReplaceKeys

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/table-keys
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.