topic Re: Unable to store time datatype values in Data Warehouse in Data Warehouse

Unable to store time datatype values in Data Warehouse

lovishsood1 — Thu, 01 Aug 2024 10:09:50 GMT

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.

Re: Unable to store time datatype values in Data Warehouse

AndyDDC — Thu, 01 Aug 2024 10:41:10 GMT

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

Re: Unable to store time datatype values in Data Warehouse

Anonymous — Fri, 02 Aug 2024 01:47:11 GMT

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!

Re: Unable to store time datatype values in Data Warehouse

lovishsood1 — Mon, 05 Aug 2024 05:41:06 GMT

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.

Re: Unable to store time datatype values in Data Warehouse

lovishsood1 — Mon, 05 Aug 2024 05:45:31 GMT

Thanks for the info mate.

I set the datatype TEXT in dataflow.