Xml.Tables is a Power Query M function that processes an XML document and organizes its content into flattened tables. The function returns the contents of the XML document as a nested collection of flattened tables.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Xml.Tables(
contents as any,
optional options as nullable record,
optional encoding as nullable number,
) as table| Argument | Attribute | Description |
|---|---|---|
| contents | ||
| options | optional | |
| 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. |
