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...
Hello,
You could check this solution to see the difference SharePoint list and SharePoint online list.
https://community.powerbi.com/t5/Desktop/Difference-between-Sharepoint-list-vs-Sharepoint-Online-List-vs/m-p/691634
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍
Thank you for your answer regarding the difference between both of lists. much appreciated
What about the date that I get in power BI is less than the sharepoint list by one day? 🙂
Thank you
Hi ahmad1987 ,
I think your problem is that powerbi gets the data in UTC.
You have to adjust the data to your local time zone.
You can read about this here: https://radacad.com/solving-dax-time-zone-issue-in-power-bi
