← Back to Binary functions

Binary.From

This function retrieves a binary value based on the input value provided. If the input value is null, the function will return null. If the input value is already in binary form, it will be returned a...

Syntax

Binary.From(value as any, optional encoding as nullable number) as nullable binary

About

This function retrieves a binary value based on the input value provided. If the input value is null, the function will return null. If the input value is already in binary form, it will be returned as is. Only values of type text can be converted to a binary value using this function. Other types of input will result in an error being returned. Please refer to Binary.FromText for more information on converting text to binary.

Explanation

Retrieve the binary representation of the input "1011" using Power Query function MBinary.From. The output will display the binary value in Base64 encoding.