Binary.Combine
BinaryCombines a list of binary values into a single binary value.
Syntax
Binary.Combine(binaries as list) as binaryParameters
| Name | Type | Required | Description |
|---|---|---|---|
binaries | list | Yes | A list of binary values to concatenate. |
Return Value
binary — A single binary value formed by concatenating all binaries in the list.
Remarks
Binary.Combine concatenates a list of binary values into a single binary value, appending each element in order. This is analogous to Text.Combine for text values.
This function is useful when you need to assemble binary data from multiple parts, such as constructing a binary protocol message with a header and payload.
Examples
Example 1: Combine two binary values
let
Part1 = Binary.FromList({72, 101, 108}),
Part2 = Binary.FromList({108, 111}),
Combined = Binary.Combine({Part1, Part2}),
AsText = Text.FromBinary(Combined)
in
AsTextApplied Steps
Converts the combined binary to text, yielding "Hello".
Value | |
|---|---|
| 1 | Hello |
Compatibility
✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks