Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DHawes
Frequent Visitor

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

1 REPLY 1
Eric_Zhang
Employee
Employee

@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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.