Record.Combine

Merges the data in the specified records. If the records contain non-data values, an error will be generated.

Generate a merged record by combining the records using Power Query M language. The MRecord.Combine function is used to merge multiple records into a single record. For example, merging a record with CustomerID 1 and Name "Bob" with another record containing Phone number "123-4567" will result in an output record containing CustomerID 1, Name "Bob", and Phone number "123-4567".