Text.FromBinary

Updated on

Text.FromBinary is a Power Query M function that decodes binary data into a text value using a specified encoding type. The function returns the decoded text value.

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

Syntax

Text.FromBinary(
   binary as nullable binary,
   optional encoding as nullable number,
) as nullable text
Argument Attribute Description
binary
encoding optional Uses the TextEncoding.Type to specify the text’s binary encoding format. By default, if not provided, the argument uses TextEncoding.Utf8 (UTF8 binary form). Other available options are:
TextEncoding.Unicode: use the UTF16 little-endian binary form.
TextEncoding.Utf16: use the UTF16 little-endian binary form.
TextEncoding.BigEndianUnicode: use the UTF16 big endian binary form.
TextEncoding.Windows: use the Windows binary form.
TextEncoding.Ascii: use the ASCII binary form.

Description

Decodes data, binary, from a binary value in to a text value, using encoding type.

Other functions related to Text.FromBinary are:

BI Gorilla Blog

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