topic Re: Fabric pipeline copy activity converts time to UTC in Pipelines

Fabric pipeline copy activity converts time to UTC

TomDA — Wed, 08 May 2024 09:36:39 GMT

I am using a pipeline copy activity to copy a table from an on-premises SQL Server database to a Fabric lakehouse, and all datetime, datetime2 and datetimeoffset columns appear to be automatially converting to UTC, from the local timezone. I don't want timestamps stored in UTC as all reporting is in local time. Is there a way to disable this?

Re: Fabric pipeline copy activity converts time to UTC

v-cboorla-msft — Wed, 08 May 2024 14:26:20 GMT

Hi TomDA

Thanks for using Microsoft Fabric Community.

At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.
Appreciate your patience.

Thanks.

Re: Fabric pipeline copy activity converts time to UTC

v-cboorla-msft — Thu, 09 May 2024 04:46:24 GMT

Hi TomDA

Apologies for the inconvenience.

Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

Re: Fabric pipeline copy activity converts time to UTC

TomDA — Thu, 09 May 2024 05:09:04 GMT

Thanks. Case 2405090030001741

Re: Fabric pipeline copy activity converts time to UTC

v-cboorla-msft — Thu, 09 May 2024 05:10:27 GMT

Hi TomDA

Thanks for sharing the details.

Re: Fabric pipeline copy activity converts time to UTC

Rk_1411 — Wed, 24 Jul 2024 03:39:36 GMT

Any update on this?

Re: Fabric pipeline copy activity converts time to UTC

TomDA — Wed, 24 Jul 2024 05:11:01 GMT

Hi Rk_1411 , no this was not resolved by MS support, they only suggested a workaround which was to convert the dates after loading, using SQL. They also recognised that it is not expected behaviour and does not occur in all regions

Re: Fabric pipeline copy activity converts time to UTC

MisterSmith — Wed, 24 Jul 2024 08:41:06 GMT

We are experencing the same issue, do you know if this is on the Fabric development team's radar to fix? As it is causing us an overhead to rectify.

Re: Fabric pipeline copy activity converts time to UTC

Rk_1411 — Fri, 26 Jul 2024 02:51:08 GMT

It is resolved for me. I updated the On pren data gateway to the latest version July 2024 and that seems to fix the issue.

Re: Fabric pipeline copy activity converts time to UTC

TomDA — Tue, 06 Aug 2024 21:31:34 GMT

Rk_1411 , thanks yes that worked for me also

Re: Fabric pipeline copy activity converts time to UTC

ChiaraMiani — Wed, 04 Sep 2024 09:03:38 GMT

Hi! Can you please give me details on the gateway you've installed?
We updated it but we still have the issue with the dates.

Thanks!

Re: Fabric pipeline copy activity converts time to UTC

mkjit256 — Fri, 25 Oct 2024 13:43:07 GMT

Any updates? I did upgrade the datagateway to the latest version, and i am still haivng the same issue. My source is an Oracle DB with a time zone America/New York and yet my dates are converted to UTC.

Re: Fabric pipeline copy activity converts time to UTC

TWorku — Thu, 05 Dec 2024 16:48:48 GMT

I had the same issue. Updating the Gateway to latest version solved the problem. Thank You community