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). ...
Thanks for the reply. In answer to your question:
SharePoint Online is UTC (London)
Power BI Desktop is English (United Kingdom)
Status:
The error is happening at the end of Mar and start of Apr. It seems to be the time portion of the date that is creating the problem
I have done two things to resolve in SharePoint
- Created a calcuated column to add 1 day to date column if after 30 Mar 19
- Removed time with TEXT() function
This has worked, but cannot be the system solution??