Forum Discussion
BUG::DFg2 TIME data type mishandling
The latter. Every single time I have a column of type TIME, when I select lakehouse as the destination, it forces me to change the data type to DATETIME because TIME is not supported. Once it brings you back to the Power Query UI (see screenshot) the TIME column, now a DATETIME type, shows the separator between date and time as ', ' that is to say a comma followed by a space, instead of just space as in SQL Server.
Ideally, the type TIME should be supported by a lakehouse, just like in a DB.
Oh I see my mistake... I was getting so upset I miswrote... of course there will be a date in the time column since it is now of type datetime. Duh. My bad.
This is currently by-design. The Delta format does not support a time type. Fundamentally, a limitation of the destination and not Dataflow Gen2.
You can suggest the idea to support a time data type for the Lakehouse using the link below:
Hey!
I'm not sure I follow. Is the issue that you're reporting around how a data type transformation occurs from a time data type to a datetime data type?
Or is the issue that you're reporting the lack of support for the time data type at the Lakehouse?
The latter. Every single time I have a column of type TIME, when I select lakehouse as the destination, it forces me to change the data type to DATETIME because TIME is not supported. Once it brings you back to the Power Query UI (see screenshot) the TIME column, now a DATETIME type, shows the separator between date and time as ', ' that is to say a comma followed by a space, instead of just space as in SQL Server.
Ideally, the type TIME should be supported by a lakehouse, just like in a DB.
Oh I see my mistake... I was getting so upset I miswrote... of course there will be a date in the time column since it is now of type datetime. Duh. My bad.
This is currently by-design. The Delta format does not support a time type. Fundamentally, a limitation of the destination and not Dataflow Gen2.
You can suggest the idea to support a time data type for the Lakehouse using the link below: