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
9 years ago

Hi

A workaround for this rather than creating a column to reformat the column is to change the ApiVersion to 14 (mine is currently 15) in the query that is used to pull the SharePoint list containing the dates.  I noticed that the date columns using Api 15 was being pulled in as text, using 14 the values are pulled in as date and are not adjusted for time zone/day light saving.

 

I found this work around when using a column containing multiple choice data. I'm not sure as yet what impact changing the Api will have on other aspects of the query. Happy for others to comment that this is a good idea or not, but it seems to work!

Kind regards

Russell

dmouser's avatar
dmouser
Frequent Visitor
8 years ago

Hello.  I'm having this problem as well.  Appears hours are showing 4 hours in the future.  Admittedly I am using an older version of desktop, but I do not have the ability to update/change.

 

I tried the workaround, but can't get through Step 3.  I'd like to address in the query editor so as not to affect/redo my formulas within the workbook itself.