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


   jsonText as any,
   optional encoding as nullable number,
) as any
Argument Attribute Description
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.


Returns the content of the JSON document.

Other functions related to Json.Document are:

BI Gorilla Blog

Last update: December 1, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/json-document
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.