Converting Local Time to EST time zone automatically with Daylight Savings

[Anonymous]

Hi Guys,

Is there a way to convert the LOCAL timezone to EST without manually doing the actual conversion like adding or subtracting hours from local time zones. Is it possible to convert it automatically and with DAYLIGHT SAVINGS ?

Thank you so much for your answer!

[edhans · Accepted solution]

No. The service is always in UTC time. You will have to do the time zone switch in Power Query. This article will show you how to do that, including the Daylight Savings adjustment.