Forum Discussion
SharePoint date changes when imported
I have a SharePoint document library that has a 'Call Date' column and four files. When I connect to this with PowerBi, it imports the dates but they are wrong. One matches, but the other three are one day behind. It looks like PowerBi has included a time column and rolled back three of the files one hour (making the date change), but the fourth is correct.
The SharePoint column is date only, no time. I've changed it to include time, which shows as 00:00 in SP for all files, but powerbi still gets it wrong.
I've also changed column types in power query. Text, date, date and time - all are wrong.
I found out how to fix it.
In advanced editor change the api version to 14.In source settings change implementation to 2.0
Then in the navigatgion step settings choose your list/library
all working.
5 Replies
Apparently this happenss because of a change in API from v14 to v15. A suggested solution is to transform the date column to 'end of day'. But this doesnt work for me. the three dates that have a time of 23:00 are correct, but the fourth with a time of 00:00 becomes the next day.
Hi, nick9one1
it's because of the timezone difference.
refer: Solved: Sharepoint vs PowerBI Time Issues - Microsoft Fabric Community
Power Query SharePoint Online list connector - Power Query | Microsoft Learn
Solved: Time Zone Issue - Microsoft Fabric Community
Solved: Date Format Changing when Published to SharePoint - Microsoft Fabric Community
no it isnt. Three of the dates are incorrect. One is correct.
A timezone mismatch would affect all dates.
I have created another test.
New column in Sharepoint 'date and time' I have set the times to 6:00.
When they are displayed in powerbi, three are incorrect '05:00' and one is correct.I found out how to fix it.
In advanced editor change the api version to 14.In source settings change implementation to 2.0
Then in the navigatgion step settings choose your list/library
all working.
