Forum Discussion

maurcoll's avatar
maurcoll
Icon for Helper IV rankHelper IV
11 months ago
Solved

Converting a date time from utc - daylight saving??

Hi

I have a sharepoint file that is generated from a power app. I have startdatetime and enddatetime columns
The issue i am having is that when i load the data from the sharepoint file into power bi desktop the hour reduces by 1 hour. This is in powerquery, I'm not sure if this will be due to daylight saving as i am in the UK or if there is another issue that could be causing this. Any help in how to convert the datetime in the column to return the correct value. I then split the column into a date and a time column.

 

for example

23/10/2025 13:10 becomes 23/10/2025 12:10

  • maurcoll You could add a step to add an hour like the following:

    AddedHours = Table.AddColumn(Source, "UpdatedDateTime", each [DateTime] + #duration(0, 1, 0, 0), type datetime)