- In the POWER QUERY ribbon tab, click From File > From XML.
- In the From XML Browse dialog box, browse for or type a file URL to import or link to a file.
- Click Open.
After the connection succeeds, you will be able to use the Navigator pane to browse and preview the collections of items in the XML file in a tabular form.
You can download the sample XML file to practice how to connect to an XML file.
= Xml.Tables(File.Contents("C:\Downloads\XML Example.xml"))