Forum Discussion
Date error due to time zone difference
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
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.
2 Replies
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.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.
