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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    HI!

     

    Thanks for the workaround! We have a SP list with Lease Renewal dates and they were coming through as 11:00pm on 31/03/2016 rather than at 00:00 on 01/04/2016 (just one instance of several)

     

    This is clearly a bug with the later API. Has it been reported anywhere so I can add my twopenneth?

     

    Thanks.

     

    Ian Watkins