Is the date being stored as a date-time data type in the underlying SharePoint list and in Power BI?
Is there any point in your query where the date is cast to an integer or other numeric type and cast back to a date type? SQL Server's date time types have a numeric representation where the date-time represented by 0 is one day more recent than that of Tabular.
I am having this exact same problem too, except the data sourc is Salesforce. In NYC, the data appears exactly right, but in the UK, everything comes in a day earlier. Even when I reformat the date in powerquery as date/time/timezone, it make no difference. We are working with case filing dates so this cannot be off by even one day. Can anyone help with an answer?
I had the same problem, dates in the summer were changing to the previous day because an hour was being taken off due to daylight saving. I found the answer in this article, a similar issue the guy was having with a CRM.
You set the imported column to data type timezone and create a new calculated column based on it with a data type date.
Here are the steps:
1. In Query Editor, rename the offending SharePoint list date column rawDate or similar
A workaround for this rather than creating a column to reformat the column is to change the ApiVersion to 14 (mine is currently 15) in the query that is used to pull the SharePoint list containing the dates. I noticed that the date columns using Api 15 was being pulled in as text, using 14 the values are pulled in as date and are not adjusted for time zone/day light saving.
I found this work around when using a column containing multiple choice data. I'm not sure as yet what impact changing the Api will have on other aspects of the query. Happy for others to comment that this is a good idea or not, but it seems to work!