Forum Discussion
maurcoll
Helper IV
11 months agoConverting 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)