Forum Discussion

matkvaid's avatar
matkvaid
Helper III
2 years ago

Copy activity UTC/local time zone conversion problem from On Prem Gateway

Hi,   i cant solve time zone issues, maybe on prem gateway should have some settings or what i should do?   1. Data source is On Prem SQL, all date/time fields are stored in UTC time; 2. Our loc...
pipelines
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi matkvaid ,

Thanks for using Fabric Community.
Can you please share the screenshots of your pipeline configuration? Also can you confirm that you did not faced this issue with dataflow gen 2 but observing with copy activity?

  • matkvaid's avatar
    matkvaid
    Helper III
    2 years ago

    Hello, 

    is this enough? Preview is from on prem SQL source, so it has correct date/time (it does not have timezone in source). In Dataflows it was correct, i was testing them from start of Fabric trial and copy date to Warehouse. Now when On Prem gateway connection is possible in Pipelines, we started moving everything to Lakehouse with Pipelines. Attaching screenshot:

     

     

    • matkvaid's avatar
      matkvaid
      Helper III
      2 years ago

      Oh and i forgot to mention - in bottom of picture, is screenshot from destination lakehouse table

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi matkvaid ,

        We have seen this issue reported by other customers too. It looks like some bug.

        Similar Issue - Fabric pipeline copy activity converts time to UTC - Microsoft Fabric Community

        I request you to please open a support ticket and have our support team take a closer look at it - Link 

         

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

         

        Hope this helps. Please let us know if you have any other queries.