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
Syntax
Lines.FromBinary(
binary as binary,
optional quoteStyle as nullable number,
optional includeLineSeparators as nullable logical,
optional encoding as nullable number,
) as list| Argument | Attribute | Description |
|---|---|---|
| binary | The binary value to transform into a list of text values. | |
| quoteStyle | optional | You can provide a QuoteStyle Type that instructs how to deal with double quote characters. You can choose from QuoteStyle.None or QuoteStyle.Csv. |
| includeLineSeparators | optional | |
| 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
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.
Related functions
Other functions related to Lines.FromBinary are:
2023-2026 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy