Forum Discussion

Regular Visitor

10 years ago

SharePoint date differs from Power BI date

Hi, I have imported data from a SharePoint list into Power BI including one column containing a date. The date in Power BI differs 1 day from the date in SharePoint. e.g. Sharepoint: 1/6/2016 >...

Frequent Visitor

7 years ago

this fixes the error

CoRouff
Regular Visitor
7 years ago
Power BI Desktop
Version : 2.61.5192.601 64-bit (août 2018)

I have the same issue and the lastest suggestion did not fix it.
Can anyone from the Power BI team react on this issue ?
Its quite annoying and a real struggle to get it working as intended without massive workarounds.
- Anonymous
  Not applicable
  7 years ago
  did you found a solution for this problem?
  - Anonymous
    Not applicable
    7 years ago
    In Power Query, I enter the following, for a column called Date.
    
    #"Replaced Value" = Table.ReplaceValue(<Source>,each [Date],each [Date]+#duration(0,1,0,0),Replacer.ReplaceValue,{"Date"}),
    For UK this will bring a 22/04 23:00 to 23/04 00:00, which I convert to Date 23/04. Outside Daylight saving, it would turn 23/04 00:00 to 23/04 01:00, which again would convert to 23/04. So for me this is enough.
    
    There is also the suggestion which works of casting to date, then date time locale, then back to date (three separate steps).

Related content