Forum Discussion
Error importing XML
Good day everyone,
Anyone have any experience on importing XML files?
I am trying to import a fairly small file but I am getting this error message:
(I have a number of files which I need to import with the same structure, but need to do the transformations on the first etc..)
Thanks!
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
7 Replies
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
JimmyThanks 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
Jimmy
