Forum Discussion
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)
3 Replies
Hi maurcoll This issue is common with SharePoint and Power BI. SharePoint saves all date and time values in UTC but shows them in your local time zone. When Power BI connects, it retrieves the original UTC values instead of the local ones.
Here is a quick fix:
Go to Power Query -> Transform Tab -> Select the Date Column -> Change Type -> Date/Time/Timezone
a popup will open select you local time to get it same as sharepoint.
Here is a details guideline
Thanks
Hi maurcoll,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Royel and GeraldGEmerick for prompt and helpful responses.
Just following up to see if the Response provided by community members were helpful in addressing the issue.
If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumarmaurcoll 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)
