Forum Discussion
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 >...
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.
Changing the API Version to 14 instead of 15 worked for me. in all site non English ADN English it has worked very well.
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.