Updated on

Lines.FromBinary is a Power Query M function that converts a binary value to a list of text values split at line breaks. The function returns a list of text values with or without line break characters based on the includeLineSeparators parameter.

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


   binary as binary,
   optional quoteStyle as nullable number,
   optional includeLineSeparators as nullable logical,
   optional encoding as nullable number,
) as list
binaryThe binary value to transform into a list of text values.
quoteStyleoptionalYou can provide a QuoteStyle Type that instructs how to deal with double quote characters. You can choose from QuoteStyle.None or QuoteStyle.Csv.
encodingoptionalUses 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.


Converts a binary value to a list of text values split at lines breaks. If a quote style is specified, then line breaks may appear within quotes. If includeLineSeparators is true, then the line break characters are included in the text.

Other functions related to Lines.FromBinary are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: