Forum Discussion

lazzarjovvch74's avatar
8 years ago
Solved

Time Zone issue

Hello,   I have a strange issue with data/time column. I have date/time column that shows correct time in Power Query but when I load data to a table I see time in another time zone (+6:00). I chan...
  • lazzarjovvch74's avatar
    lazzarjovvch74
    8 years ago

    Yes, I'm 2 hours ahead of GMT (Central European Time), andI want to present data based on EST time (NYC time). What I did so far:

    My PC settings is English (United States). Power BI settings is Enhlish (US) too.

    I have "Time" column that shows GMT time (see below):

     

    Then I added Local Time column in Power Query Edutor that converts GMT from Time column to local time (-4:00). And I got what I wanted in Power Query Editor.

     

    But, a problem arises here. When I load Local Time data to a table I see my Central European time in the table column despite my PC settings and Power BI settings are English (US).

    So instead of 9:45:54AM as in Power Query Editor, I see 3:45:54PM in my table.

     

    I am curious to know why this happen. The local time that I see in Power Query Editor should be loaded to my table if the settings is correct. 

     

    In the meantime I solved this by adding another column to a table with a formula, but it would be great if I can do this without additional column.

    LocalTime 2 = MyTable[LocalTime] - .25 ---> 0.25 = 6/24 (I am 6 hours ahead of EST).

     

    ------

     

    How I got the local time:

     

    =DateTimeZone.ToLocal([start_time])

     

    Where [start-time] column shows time from my server (GMT) that is converted to local time (EST).