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. |