Date field & Using Locale

[Tob_P]

Hi,

I'm having an issue with one of my reports whereby a date field is essentially an hour out. When refreshing an imported dataset, the date field displays correctly in the .pbix file and when published to Service, behaves as expected until the refreshes kick in and it all goes out of kilter again. Long story short, Microsoft have looked into the issue and said it's a modelling problem - don't agree with this as if I take the report down to one constitutent table, then the same thing happens which leaves it down to me to try and figure out.

I've taken a copy of the date column, and Changed Type with Locale in Query Editor, with Data Type of Date/Time/Timezone with Locale of English (United Kingdom) with the result being that I can see a mixture of timezones...

Now I'm not pretending that I know that this is the issue, but seems odd that there's a mix. The field it's taken from in my CRM is solely a Date field, not timestamps at all and have investigated the CRM timezone settings and have ruled that out as an issue.

What I would like to know is how I can changed any of the +00:00 entries in this column to +01.00?

Guidance & help appreciated.

[Syndicate_Admin · Accepted solution]

This is working as designed.  Some dates are in  Standard Time and some dates are in Daylight Saving Time.