Forum Discussion

rupertdenny's avatar
rupertdenny
Regular Visitor
6 years ago
Solved

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

 

 

 

2 Replies