Forum Discussion

HenryH's avatar
HenryH
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 >...
dannn777's avatar
dannn777
Frequent Visitor
8 years ago

this fixes the error

 

 

CoRouff's avatar
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's avatar
    Anonymous
    Not applicable
    7 years ago

    did you found a solution for this problem?

    • Anonymous's avatar
      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).

       

      • Ricsta's avatar
        Ricsta
        Frequent Visitor
        7 years ago

        I tried the date time locale alternative, which almost fooled me to think it was working, but as soon as I published the report online it reverted (I reckoned it used another source for the date time locale setting after being published).