Binary.ApproximateLength

Updated on

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 ) )

Other functions related to Binary.ApproximateLength are:

BI Gorilla Blog

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