How to change the timezone when using Direct Query on Power BI Desktop

[Anonymous]

Hi,

I am trying to figure to format the date/time but unable to do so. After I use a direct query I get date/time in (2020/02/02 11:09:00 -04:00), though when I run the query in sql editor I get the date/time in (-05:00 UTC). Because of which I use a date slicer to get ceratin data, I get 5 hours before the start date and which offsets 5 hours for the end date. 

Is it possible to conver the following date/time? Or is there any other way to get exact amont of data requested?

[VasTg]

@Anonymous 

I believe power bi is based on UTC timezone across the globe. You have to manipulate your Date/Time column as per your need.

+5 for EST.

Refer to this article..

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/

If it helps, mark it as a solution
Kudos are nice too

[Anonymous]

Hi,

When I get the data in Power BI Desktop, it is in (-04:00). I tried converting it in UTC, it won't work.

[v-lionel-msft]

Hi @Anonymous ,

It's impossibl to realize your idea in current version(2.76.5678.782 64-bit (December 2019)).

Maybe you can Submit your ideas .

Best regards,
Lionel Chen

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