Hi, We are building a simple table report from a SharePoint Online list. The dates in the PowerBI column are one day before the dates in the SharePoint list (e.g 2 Apr 19 (SP) = 1 Apr 19 (PBi). ...
Hi Chrisstott,
Is your date column within the SharePoint list also has time value appended?
Based on my research, the date time display in the Power BI desktop is using UTC zone. In your scenario, as London uses DST UTC+1 starts from 31 Mar 2019, if you type 02/04/2019 00:30 in SharePoint list, it's in UTC+1 format, when we retrieve data in Power BI desktop, it will display in UTC format then it displays 4/1/2019 11:30:00 PM.
Best Regards,
Qiuyun Yu