Record.Combine is a Power Query M function that combines the records in the given records. The function returns a single record that contains all the fields from the input records, or an error if any input value is not a record.

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


Record.Combine( records as list ) as record


Combines the records in the given records. If the records contains non-record values, an error is returned.


Create a combined record from the records.

// Output: [CustomerID = 1, Name = "Bob", Phone = "123-4567"]
Record.Combine( {
    [CustomerID = 1, Name = "Bob"],
    [Phone = "123-4567"]
} )

Other functions related to Record.Combine are:

BI Gorilla Youtube Channel

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.