Xml.Document

Updated on

Xml.Document is a Power Query M function that processes an XML document and organizes its content hierarchically. The function returns the contents of the XML document as a hierarchical table.

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

Syntax

Xml.Document(
   contents as any,
   optional encoding as nullable number,
) as table
Argument Attribute Description
contents
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 contents of the XML document as a hierarchical table.

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