#binary

Updated on

#binary is a Power Query M function that creates a binary value from a list of numbers or a base 64 encoded text value.

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

Syntax

#binary( value as any ) as any

Description

Creates a binary value from a list of numbers or a base 64 encoded text value.

Examples

Create a binary value from a list of numbers.

#binary( { 0x30, 0x31, 0x32 } ) // Returns Text.ToBinary( "012" )

Create a binary value from a base 64 encoded text value.

#binary( "1011" ) // Returns Binary.FromText( "1011", BinaryEncoding.Base64 )

Other functions related to #binary are:

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