Forum Discussion
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 >...
Is the date being stored as a date-time data type in the underlying SharePoint list and in Power BI?
Is there any point in your query where the date is cast to an integer or other numeric type and cast back to a date type? SQL Server's date time types have a numeric representation where the date-time represented by 0 is one day more recent than that of Tabular.
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.
