Json.Document

Updated on

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.

Description

Returns the content of the JSON document.

Other functions related to Json.Document are:

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