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 >...
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). 

manojnikam3008's avatar
manojnikam3008
Frequent Visitor
4 years ago

Did you find the solution? I have the same problem. I was able to handle this change using  -> change column format to Date/time/timezone> 'Locale' option > change it back to Date/time and It worked me but after report was published it is again back to what it was. Now, i have correct dates in the PBIX file but wrong dates on the pbulsihed report.

  • danielH's avatar
    danielH
    Helper I
    4 years ago

    Changing the API Version to 14 instead of 15 worked for me. in all site non English ADN English it has worked very well. 

    • manojnikam3008's avatar
      manojnikam3008
      Frequent Visitor
      4 years ago

      I have tried that but did not work for me. For now, i am using alternative solution of adding one extra day to the actual date but i don't want to rely on this in long term.