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 >...
HenryH's avatar
HenryH
Regular Visitor
10 years ago

In SharePoint the date is indeed being stored as a "Date and Time".

In Power BI, in the initial Query result, the date is already changed to one day earlier.

 

I did find out that dates that are stored by SharePoint itself (created date, modified date, etc.) are correct in Power BI.

However, they are also of type "Date and Time", so I don't see what's different.

kmarcum's avatar
kmarcum
New Member
10 years ago

Ive just noticed this same thing but even my modified and created dates are wrong.  Did you ever figure this out?

  • HenryH's avatar
    HenryH
    Regular Visitor
    10 years ago

    Nope, didn't yet figure it out.

    Have you tried creating or modifying something at different times during the day to make sure it's not a time zone issue?