Connect To Xml File Power Query. In the Query Wizard expand the node for the table you would like to import into your spreadsheet. This video talks aboutLoad Xml Files in Power BIxml files in power biimport xml files in power bixml in power bixml files in power bi.
Select the xml file that contains the data. This will open up the Power Query Editor. Or some such to a file and then append the output from your GetXML method so you have a much neater formatted piece of XML.
Let take a closer look at how you can import XML files into Excel.
Once you click on the connect option in Power BI it. To start the process of combining multiple files first ensure that all the files you want to combine are contained in a single file folder. Power Query reads legacy workbooks such as xls or xlsb use the Access Database Engine or ACE OLEDB provider. Or some such to a file and then append the output from your GetXML method so you have a much neater formatted piece of XML.