Records in Power Query

The record in Power Query is nothing we can consider a single row of a table, where each record has the field name(s) which is nothing but the column name, and its value(s).

Example: Create a record in the power query.

Power Query M

let
    Source = [ Name = "Ashish Goel", Company = "TCS", Education = "MTech" ]
in
    Source 

The output of the above code is shown below:

Accessing Record Field Value

To access the field value from the record, use the field name within square brackets.

Syntax [Record][Field_name]

Example:

Power Query M

let
    Source = [ Name = "Ashish Goel", Company = "TCS", Education = "MTech" ][Name]
in
    Source 

The output of the above code is “Ashish Goel”.