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.
[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 ?