Forum Discussion
stribor45
Post Prodigy
Post ProdigyTimezone EST and UTC issues - Incremental Refresh and Power BI Service
I had some issues with incremental refresh but after I solved that with help from this forum now I have whole another issues with timezones. I have power query which calls external API and since I am...
rubayatyasmin
Community Champion
Community ChampionHi, stribor45
Try exploring Date timezone.SwitchZone and To local() in PQ.
Refer: https://learn.microsoft.com/en-us/powerquery-m/datetimezone-switchzone
https://learn.microsoft.com/en-us/powerquery-m/datetimezone-tolocal
Alternatively you can use Dax to solve the Viz problem.
Use Dateadd and -5, hour as the solution along with your UTC date time column name.
stribor45Post Prodigy
Post ProdigyCan you make a small example if possible? It would be much appreciated. I dont understand how in power query I can use UTC and then in Service somehow have slider that would use my EST time?
- lbendlin
Super User
EST? where are you located? Or did you mean EDT ?
- stribor45
EST Toronto area
- lbendlin
According to this Time Zones in Canada (timeanddate.com) you are currently on EDT.
