Binary.ApproximateLength

Binary.ApproximateLength is a Power Query M function that estimates the length of a binary or returns an error if the data source doesn’t support an approximate length. The function returns the approximate length of the binary.

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

Syntax

Binary.ApproximateLength( binary as nullable binary ) as nullable number

Description

Returns the approximate length of binary, or an error if the data source doesn’t support an approximate length.

Examples

Get the approximate length of the binary value.

// Output: 9
Binary.ApproximateLength( Binary.FromText( "i45WMlSKjQUA", BinaryEncoding.Base64 ) )

Related functions

Other functions related to Binary.ApproximateLength are:

• Binary.InferContentType
• Binary.Length

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/binary-approximatelength