Forum Discussion
Error importing XML
Hello PaulDBrown
have you been able to solve the problem with the replies given?
If so, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
All the best
Jimmy
Hello PaulDBrown
I've never encountered problems when working with xml. Did you experiment with the encoding option in the third parameter of Xml.Tables?
If the file doesn't contain any sensible data, you can copy it to ondrive and link it here, so I could give it a test
Hello
I would suggest you post here the current datatable from your Power BI (go to the Table in Power BI, click on the upper left symbol and select copy table) and post the table here in the forum. Please change the data if contains sensitive information.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Thanks for looking into this. Here is the rogue file:
Hello PaulDBrown
i was able to open the xml file. This xml-file however doesn't represent a table, but Excel-file. Try to open the xml-file with excel instead to check-out the data. However, also with the xml-function you should get somehow the data
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
JimmyThanks Jimmy for looking into this. How did you get PQ to read the XML file? (I tried using the XML as source first, then tried the Excel option; neither worked)
I finally resorted to saving each XML file as an Excel file (the files were of no considerable size or row count, so it was ok) and doing the transformations etc. on those. Bit of a pain, but anyway.
Thanks again.
