Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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 > Power BI: 1/5/2016
Is this related to time zone differences and how can I fix this except for adding a new column adding one day?
Kind regards,
Henry
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.
Ive just noticed this same thing but even my modified and created dates are wrong. Did you ever figure this out?
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?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 61 | |
| 52 | |
| 47 | |
| 41 | |
| 38 |