Forum Discussion
Day Light Saving
Hello,
Day light savings are causing me a bit of headache. I am hoping someone has the answer to this
I am in the UK, the database is in the UK and I am providing reports to people also in the UK.
The table below are two date time fields either side of the day light saving change in March this year. The database is showing the time date and times that I would like to end up in the report
This table is showing the time zone which is applied on each field
When I load into the desktop model both these fields have changed to UTC +1 when only the second field is actually UTC +1. This is the same in the editor aswell as the desktop
When uploaded to the service and performed an on demand referesh. Both of these fields have changed to UTC
Is there a way of using the data time used on the database and not allow Power BI to adjust these fields. I have a fix in place which has shift everything to UTC +1 which works for the next few months but I would prefer not to have to make these changes twice a year.
Thank you
Hi , rupertdenny
Pls refer to these related post for possible solutions.
Solving DAX Time Zone Issue in Power BI
Convert UTC to Local Time with Daylight Savings Support in Power BI
Best Regards,
Community Support Team _ Eason
2 Replies
- Greg_DecklerCommunity Champion
Hmm, interesting that it seems to be ignoring the timezone. The way you are doing it is essentially how I did it in my book, I computed the UTC offset as a time decimal, [UTC Offset] / 24 and then just added that to the date/time value.
- v-easonf-msftCommunity Support
Hi , rupertdenny
Pls refer to these related post for possible solutions.
Solving DAX Time Zone Issue in Power BI
Convert UTC to Local Time with Daylight Savings Support in Power BI
Best Regards,
Community Support Team _ Eason