Unable to store time datatype values in Data Warehouse

[lovishsood1]

Hi Everyone,

I'm currently working on one project on Fabric in which I want to store Time data type values in Warehouse but it is throwing me some error when I'm trying to publish one dataflow.

I tried Lakehouse as well but same error I'm receiving. Is there any solution to store it?

I need to create measures based on this column that's why I need in Time Datatype instead of Text Datatype.

[v-huijiey-msft]

Hi @lovishsood1 ,

Thanks for the reply from @AndyDDC .

I reproduced your error:

Changing the type to Date/Time fixes it.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[lovishsood1]

Nope, date/time datatype won't fix it since when I'm calling this column in Power BI. It is showing me a Fixed Date along with the Time. So I'm not able to perform any calculations.

[AndyDDC]

Hi @lovishsood1 Fabric Warehouse supports up to 6 digits of precision for time.  You'll need to modify the dataflow to remove the 7th digit of precision (if it exists).  E.G 23:59:59.9999999 is not supported but 23:59:59.999999 would be

Data types - Microsoft Fabric | Microsoft Learn

[lovishsood1 · Accepted solution]

Thanks for the info mate.

I set the datatype TEXT in dataflow.