Binary Functions Overview

Explore Binary Functions in Power Query M Language, essential for carrying out binary operations on data in manipulation tasks. This page provides a comprehensive list and descriptions of Binary Functions available in the M Language.

Table of contents

Explore Binary Functions in Power Query M Language, essential for carrying out binary operations on data in manipulation tasks. This page provides a comprehensive list and descriptions of Binary Functions available in the M Language.

Buffer and Compression Functions

FunctionDescriptionInputOutput
Binary.BufferBuffers the binary value in memory.BinaryBinary
Binary.CompressCompresses a binary value using the given compression type.BinaryBinary
Binary.DecompressDecompresses a binary value using the given compression type.BinaryBinary

Byte Order Functions

FunctionDescriptionInputOutput
BinaryFormat.ByteOrderReturns a binary format with the byte order specified by a function.FunctionFunction

Creation and Conversion Functions

FunctionDescriptionInputOutput
#binaryCreates a binary value from a list of numbers or a base 64 encoded text value.AnyAny
Binary.FromCreates a binary from the given valueAnyBinary
Binary.FromListConverts a list of numbers into a binary value.ListBinary
Binary.FromTextDecodes data from a text form into binary.TextBinary
Binary.ToListConverts a binary value into a list of numbers.BinaryList
Binary.ToTextEncodes binary data into a text form.BinaryText

Information Functions

FunctionDescriptionInputOutput
Binary.ApproximateLengthReturns the approximate length of the binary.BinaryNumber
Binary.InferContentTypeReads the binary stream and tries to determine the content type and format information of the stream.BinaryRecord
Binary.LengthReturns the number of characters.BinaryNumber

Reading Functions

FunctionDescriptionInputOutput
BinaryFormat.7BitEncodedSignedIntegerA binary format that reads a 64-bit signed integer that was encoded using a 7-bit variable-length encoding.BinaryAny
BinaryFormat.7BitEncodedUnsignedIntegerA binary format that reads a 64-bit unsigned integer that was encoded using a 7-bit variable-length encoding.BinaryAny
BinaryFormat.BinaryReturns a binary format that reads a binary value.AnyFunction
BinaryFormat.ByteA binary format that reads an 8-bit unsigned integer.BinaryAny
BinaryFormat.ChoiceReturns a binary format that chooses the next binary format based on a value that has already been read.FunctionFunction
BinaryFormat.DecimalA binary format that reads a .NET 16-byte decimal value.BinaryAny
BinaryFormat.DoubleA binary format that reads an 8-byte IEEE double-precision floating point value.BinaryAny
BinaryFormat.GroupReturns a binary format that reads a group of items.FunctionFunction
BinaryFormat.LengthReturns a binary format that limits the amount of data that can be read.FunctionFunction
BinaryFormat.ListReturns a binary format that reads a sequence of items and returns a list.FunctionFunction
BinaryFormat.NullA binary format that reads zero bytes and returns null.BinaryAny
BinaryFormat.RecordReturns a binary format that reads a record.RecordFunction
BinaryFormat.SignedInteger16A binary format that reads a 16-bit signed integer.BinaryAny
BinaryFormat.SignedInteger32A binary format that reads a 32-bit signed integer.BinaryAny
BinaryFormat.SignedInteger64A binary format that reads a 64-bit signed integer.BinaryAny
BinaryFormat.SingleA binary format that reads a 4-byte IEEE single-precision floating point value.BinaryAny
BinaryFormat.TextReturns a binary format that reads a text value.AnyFunction
BinaryFormat.TransformReturns a binary format that will transform the values read by another binary format.FunctionFunction
BinaryFormat.UnsignedInteger16A binary format that reads a 16-bit unsigned integer.BinaryAny
BinaryFormat.UnsignedInteger32A binary format that reads a 32-bit unsigned integer.BinaryAny
BinaryFormat.UnsignedInteger64A binary format that reads a 64-bit unsigned integer.BinaryAny

Transformation Functions

FunctionDescriptionInputOutput
Binary.CombineCombines a list of binaries into a single binary.ListBinary
Binary.EndReturns the end of a binary value.BinaryBinary
Binary.RangeReturns a subset of the binary value beginning at an offset.BinaryBinary
Binary.SplitSplits the specified binary into a list of binaries using the specified page size.BinaryList

View Functions

FunctionDescriptionInputOutput
Binary.ViewCreates or extends a binary with user-defined handlers for query and action operations.BinaryBinary
Binary.ViewErrorCreates a modified error record which won’t trigger a fallback when thrown by a handler defined on a view (via Binary.View).RecordRecord
Binary.ViewFunctionCreates a function that can be intercepted by a handler defined on a view (via Binary.View).FunctionFunction
BI Gorilla Blog

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