Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sharepoint list : Odata vs Connector

I read couple of articles saying the two methods look like the same (odata versus sharepoint connector).  I have one concerned and would love hearing your advices on this :  - I created a dashboard...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    As @ mahoneypat mentioned, SharePoint stores datetime field values in UTC format. When you get datetime from SharePoint, you can use DateTimeZone.ToLocal() function in power query to transform the datetime to your local time to compare it with the OData datatime to check.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

edhans's avatar
edhans
Community Champion
5 years ago

Is that was is loading to the data model? Sometimes Power Query will show cached data in the display, but the actual data will load properly as the cache isn't used during the load.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you Edhans, I don't think it comes from the cache because I checked all the possible scenario before, after loading and always same result: gap in date!