Xml.Tables

This function retrieves the data from the XML document and organizes it into a structured format of nested tables.

Syntax

Xml.Tables(contents as any, optional options as nullable record, optional encoding as nullable number) as table.

About

This function retrieves the data from the XML document and organizes it into a structured format of nested tables.

Explanation

Extract the information stored in a local XML file. Utilize Power Query function MXml.Tables(File.Contents("C:\invoices.xml")) to bring the data into a table format for further analysis and processing.