Json.Document is a Power Query M function that parses a JSON document. The function returns the content of the JSON document.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Json.Document(
jsonText as any,
optional encoding as nullable number,
) as any| Argument | Attribute | Description |
|---|---|---|
| jsonText | ||
| 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. |
