Wrong date/time for Sharepoint list date fields in Power BI

[TrulsBj]

Hi, 

I have Connected to Shaepoint Online list, and the date Fields are wrong in Power BI. For SP Fields With date/time - it is 2 hour wrong, for dates only Field, the date  is 1 day wrong.  Im located in Norway. 

examlpe: 

[Stop date] Field in Sharepoint: 1.10.2019

[Stop date] Field in Power BI: 30.9.2019

[Created] Field in Sharepoint: 1.10.2019 11:10

[Created] Field in Power BI: 1.10.2019 09:10

 (2 hour difference)

After October 27th, the time difference in clock is 1 hour.  This seems to be a Daylight savings  problem. 

Is it a easy way to change this to be correct, and is it possible to send a report file With the correct formulas ?

[v-chuncz-msft · Accepted solution]

@TrulsBj 

Here is a similar case for your reference.

https://community.powerbi.com/t5/Desktop/Created-time-for-records-is-changing-when-connected-to-onli...