Forum Discussion

maurcoll's avatar
maurcoll
Icon for Helper IV rankHelper IV
1 year 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 b...
Need Help
  • GeraldGEmerick's avatar
    GeraldGEmerick
    1 year ago

    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)
Royel's avatar
Royel
Icon for Super User rankSuper User
1 year ago

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