Date error due to time zone difference

[nikhil0511]

Hello 

When I import the data from the excel share point to the Power BI data flow, the Date columns are imported incorrectly.

Date in sharepoint is 07/23/2021 00:00 AM UTC where as in data flow tables it shows 07/22/2021 10:00 PM CEST. this is also incorrect as it should give 07/23/2021 02:00 AM CEST or 07/23/2021 01:00 CET

How can I fix this in data flow? The first image is from share point and second from the data flow

PS: My time zone has +1 time difference in winter and +2 difference in summer

 

[nikhil0511]

Thank you @Anonymous 

I followed another approach to change the date time zone.

created an invoked function as suggested in another thread from this forum.

https://community.powerbi.com/t5/Power-Query/Convert-Date-Time-in-UTC-to-Local-Time-with-Daylight-savings/m-p/790149#M26463

[Anonymous · Accepted solution]

Hi @nikhil0511 ,

To my knowledge, currently all the servers for Power BI are set in the UTC Timezone

You can use DateTime.AddZone function to achieve your requirement. This function adds the timezonehours as an offset to the input datetime value and returns a new datetimezone value.

DateTime.AddZone([Date],-12)

Here is a related blog post : Power BI – Did you know ALL Power BI Services Servers are in UTC? Now how to handle it for Dates & T...

Similar threads:

https://community.powerbi.com/t5/Service/changing-timezone-of-powerbi-service/m-p/153663

https://community.powerbi.com/t5/Desktop/Issue-with-Timezone-Conversion/m-p/1852857

https://community.powerbi.com/t5/Desktop/TimeZone-problems/m-p/171245

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.