Query problem from XML resulting in a table instead of date

[DHawes]

I am loading from an xml file wit a date/time/timezone format field and some are input fine as text whichc an be chanegd to date/time but some result in a  "table" data type which when expanded is labeled "Element:Text" and seems to just be the same as the other dates.

Appreciate any suggestions

[Eric_Zhang]

@DHawes

Somewhat I've confirmed a similar behavior when extract data from an XML in Power BI desktop. Please check this thread. I've reported it internally and so far there's only some workaround.

Could you share the XML that leads to the behavior in your case?