Xml.Tables

Updated on

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.

Description

Returns the contents of the XML document as a nested collection of flattened tables.

Examples

Retrieve the contents of a local xml file.

// Output: table
Xml.Tables( File.Contents( "C:invoices.xml" ) )

Other functions related to Xml.Tables are:

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