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 >...
danielH's avatar
danielH
Helper I
8 years ago

This issue was resolved, yet since this month update it started again. could you please have a look ? 

i check with the API 14 and it works. but this is just a work around. 

nate_bd's avatar
nate_bd
New Member
8 years ago

I know this isn't strictly related, however there are similarities to what I've just encountered while working on an SPFx solution where we're duplicating SharePoint Events that have a recurrence set.

 

There appears to be a mismatch between the server generated timestamp (which appears to be UTC) and the FieldValuesAsX (X = Text or HTML). I believe that the base DateTime properties persist to maintain back end continuity, and the SharePoint Regional settings dictate what is seen within FieldValuesAsX.

 

Here's what I saw within the console.

 

odata.type:"SP.Data.EventsListItem"
EndDate:"2018-08-11T05:00:00Z"
EventDate:"2018-08-10T21:00:00Z"

FieldValuesAsText:
EndDate:"11/08/2018 5:00 p.m."
EventDate:"11/08/2018 9:00 a.m."
odata.type:"SP.FieldStringValues"

 

I don't know whether this will help anyone here, however this enabled me to track down my non-PowerBI issue that is similar...

 

I'll see myself out now :)