topic Re: How to create proper Time zone convertions, including DST in Data Warehouse

How to create proper Time zone convertions, including DST

Fleurclaes — Tue, 29 Apr 2025 06:55:53 GMT

Hi everyone,

I have a modified on and created on column, which show date time zones in UTC. However, I want to convert these date/times to W. Europe Standard Time (UTC +1), taking DST into account.

Can anyone help me with achieving this?

Thanks in advance.

Kind regards,

Fleur

Re: How to create proper Time zone convertions, including DST

lbendlin — Tue, 29 Apr 2025 11:26:12 GMT

in your warehouse keep all timestamps as UTC. Let the user's browser do the conversion to their local timezone (including DST)

Re: How to create proper Time zone convertions, including DST

v-prasare — Mon, 05 May 2025 11:34:32 GMT

Hi Fleurclaes,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: How to create proper Time zone convertions, including DST

v-prasare — Thu, 08 May 2025 13:16:25 GMT

Fleurclaes, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: How to create proper Time zone convertions, including DST

v-prasare — Mon, 12 May 2025 11:49:55 GMT

@Fleurclaes, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: How to create proper Time zone convertions, including DST

Fleurclaes — Mon, 12 May 2025 11:55:49 GMT

v-prasare This worked, I made the conversion in the views instead of the entities.