SharePoint date differs from Power BI date

Hi Fyouri,

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

= ( Table.RenameColumns(#"Changed Type",{{"Date", "rawDate"}})

2. Set the data type of this column to be Date/Time/Timezone

= Table.TransformColumnTypes(#"Renamed Columns",{{"rawDate", type datetimezone}})

3. Create a new calculated column that looks at rawDate, call it Date and set its data type to Date

= Table.TransformColumnTypes(#"Added Custom",{{"Date", type datetime}})

The result looks like this. You can see in row 1 the original date was 2/8/2015, the calculated one is 3/8/2015: