topic Re: Time difference between Dataverse and Fabric ShortCut in Data Engineering

Time difference between Dataverse and Fabric ShortCut

vivien57 — Fri, 04 Oct 2024 14:12:01 GMT

Hello everyone,

We have a Dataverse shortcut in a Fabric lakehouse.

We've noticed that the times are not the same between the data in the Dataverse (for example, a date field has the value 2024-01-31 22:42) and the operation of the shortcut in Fabric, where the same date has the value 2024-01-31 21:42.

I imagine this is because the Dataverse is in West Europe whereas the Fabric capacity/tenant is in North Europe.

However do you have any idea how to correct this without doing timezone conversions.

Thank you in advance for your help,

Vivien

Re: Time difference between Dataverse and Fabric ShortCut

tharunkumarRTK — Sat, 05 Oct 2024 16:11:10 GMT

@vivien57

I am assuming you leveraged 'Fabric link' in dataverse to create a shortcut in fabric lakehouse. With this setup, your tiemstamps would be converted to UTC. You can checkout this video for more info

https://www.youtube.com/watch?v=-qWvy_-lNgI

You need to transform your timestamp columns to an appropriate timezone

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

Re: Time difference between Dataverse and Fabric ShortCut

Anonymous — Mon, 07 Oct 2024 02:03:21 GMT

Hi @vivien57 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: Time difference between Dataverse and Fabric ShortCut

vivien57 — Mon, 20 Jan 2025 11:35:33 GMT

Hello,

Isn't there a more acceptable solution? Isn't it possible to keep the times as they are in the data source?

Thank you in advance for your feedback,