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

Bumping this.

I have seen this issue posted many times with no clear resolution for it. At the moment, all I can think of is to add an hour to the dates to bring them to the correct date, but that doesn't seem reliable. Changing the Locale doesn't make a difference either. Only changing the API Version to 14 does.

Any help?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Last bump.

I have just resorted to adding an hour to the date before I convert from datetime to date.