Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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?
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |