Forum Discussion

matkvaid's avatar
matkvaid
Icon for Helper III rankHelper 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
matkvaid's avatar
matkvaid
Icon for Helper III rankHelper 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
Icon for Helper III rankHelper 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.

    • matkvaid's avatar
      matkvaid
      Icon for Helper III rankHelper III
      2 years ago

      Support request ID is 2405220050002839 - it is strange how You already know about the issue, but seems nothing is done about that... 🙂 

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi matkvaid ,

        Thanks for sharing the support ticket.

        Please allow some time, so team can check and provide a resolution.

        In case if you got a resolution please do share with the community as it can be helpful to others .