Forum Discussion

DHawes's avatar
DHawes
Frequent Visitor
10 years ago

Query problem from XML resulting in a table instead of date

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

Need Help

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    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?