#binary

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

Related functions

Other functions related to #binary are:

• #date
• #datetime
• #datetimezone
• #duration
• #table
• #time

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