Advocate IEnable 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.
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?
1 Comment
I have experienced a likewise issue, when simply copying data from one warehouse to another (separate workspaces). My issue is not with a dataflow, but with a copy activity.
