Forum Discussion
Solved
Sharepoint List Date/Time Incorrect in PowerBi but Regional Site Settings are correct
The date time between Sharepoint and Powerbi is incorrect, is there any way to fix this without editing each column in Powerbi with a date add + 2 hours formula? Can I change a regional setting some...
To fix I just went to the advanced editor and added an applied step per column that altered the time per column.
#"Inspection planned" and #"Inspection actual".
let Source = SharePoint.Tables("https://company.sharepoint.com/sites/Transport", [Implementation=null, ApiVersion=15]), #"idstuff" = Source{[Id="idstuff"]}[Items], #"Renamed Columns" = Table.RenameColumns(#"idstuff",{{"ID", "ID.1"}}), #"Removed Duplicates" = Table.Distinct(#"Renamed Columns", {"Title"}), #"Inspection planned" = Table.TransformColumns(#"Removed Duplicates",{"Inspection planned", each _ + #duration(0,2,0,0)}), #"Inspection actual" = Table.TransformColumns(#"Inspection planned",{"Inspection actual", each _ + #duration(0,2,0,0)}) in #"Inspection actual"
To fix I just went to the advanced editor and added an applied step per column that altered the time per column.
#"Inspection planned" and #"Inspection actual".
let
Source = SharePoint.Tables("https://company.sharepoint.com/sites/Transport", [Implementation=null, ApiVersion=15]),
#"idstuff" = Source{[Id="idstuff"]}[Items],
#"Renamed Columns" = Table.RenameColumns(#"idstuff",{{"ID", "ID.1"}}),
#"Removed Duplicates" = Table.Distinct(#"Renamed Columns", {"Title"}),
#"Inspection planned" = Table.TransformColumns(#"Removed Duplicates",{"Inspection planned", each _ + #duration(0,2,0,0)}),
#"Inspection actual" = Table.TransformColumns(#"Inspection planned",{"Inspection actual", each _ + #duration(0,2,0,0)})
in
#"Inspection actual"