Forum Discussion
Get data from SharePoint list : Incorrect Date
Dear All Please note that when i get the data from the SharePoint list the date in powerBI appears one day before the correct date. e.g in SharePoint, the date is 1 December 2022 and in power...
Thank you for your reply.
Please note that the problem is that the difference is one day and not hours. Please see the attached photoes
- grandtotal
Resolver III
but still this difference could be 1 hour...
Can you check the second table with Date/Time format?
- grandtotal
It's 1 hour so I'm pretty sure it is a timezone issue.
You can check your Sharepoint settings: https://sharepointmaven.com/sharepoint-time-zone/
Or you can adjust it in your guery: https://community.powerbi.com/t5/Service/Incorrect-Time-Zone-setting-at-Power-BI-Service/m-p/2345390/highlight/true#M152137
