Forum Discussion

vivien57's avatar
vivien57
Super User
1 year ago
Solved

Time difference between Dataverse and Fabric ShortCut

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 ...
lakehouse
  • tharunkumarRTK's avatar
    tharunkumarRTK
    1 year ago

    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!

     

     

tharunkumarRTK's avatar
tharunkumarRTK
Super User
1 year ago

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!