Forum Discussion

VFDD's avatar
VFDD
New Member
4 years ago

Sharepoint Data, date is off by one day

Yes another one of those off by one day issue !    So when I use sharepoint list as data source for Power Query some of my records have the date off by one day .    I have read I think all of the p...
Need Help
Marty_Seelbach's avatar
Marty_Seelbach
Regular Visitor
2 years ago

I've recently had same issue. Checked all the Time settings were matching but without sucess.

Then found someone recommened the Get Data using the Online Services with SharePoint Online List and switch the Implementstion setting option from 1.0 to 2.0. This worked for me.

Instead of going through the Get Data process I just changed my code in Advanced Editor from 

     Source = SharePoint.Tables(p_SharePointRoot & p_SharePointSite2, [ApiVersion = 15]), to

     Source = SharePoint.Tables(p_SharePointRoot & p_SharePointSite2, [Implementation="2.0", ViewMode="All"])

Note p_SharePointRoot & p_SharePointSite2 are just parameters for my SP locations you can just use the SP List url here too.

 

Posted response to help anyone encountering issue as it took me a little searching and tweaking files / platforms before resolving.

  • Tunde_olakanye's avatar
    Tunde_olakanye
    New Member
    1 year ago

    Thanks so much. This works for me.