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

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Enable writing PowerQuery type time (from Dataflow Gen2) to Warehouse type time

Currently the UI throws an error while I am trying to write Data typed as "time" in Power Query to a Fabric Warehouse.

pyd4life_0-1779090254920.png


I would prefer to import data typed as "time" in Dataflow Gen2 PowerQuery to a Fabric Warehouse Table Column of type "time" in line with hh:mm:ss[.nnnnnnn] as described here: time (Transact-SQL) - SQL Server | Microsoft Learn

 

To me, it seems very unintuitive since the type "time" is already supported by warehouse tables as documented here: Data Types in Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn

It feels wrong to rely on type "text" or "datetime" in the Dataflow PowerQuery... Are there any best practices to work around this at the moment?

Status: New