Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Time difference between Desktop and service

I created a card visual that would show the date and time of the last refresh using this code.

 For the Table:

 #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})

 For the measure:

Last Refreshed (Local) = LASTDATE('refresh'[LastRefresh])
 
now when I refresh on the Desktop and publish. it reads the time correctly. but when the PowerBi service scheduled refresh runs, the time shows one hour less than the local time. For example, if I have a scheduled refresh for 10am, by the time the power bi service refreshes successfully and I check the dashboard, it shows refresh time as 9am.
how do I rectify this?
NB: the gateway is installed on my local computer.
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Anonymous,

    Power bi service does not support display with specific date timezone values, it will conver these datetiem feilds to UTC format.

    For this scenario, you can add a calculated column to manually add timezone offset to show the specific date timezone value on the power bi service side.
    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Anonymous,

    Power bi service does not support display with specific date timezone values, it will conver these datetiem feilds to UTC format.

    For this scenario, you can add a calculated column to manually add timezone offset to show the specific date timezone value on the power bi service side.
    Regards,

    Xiaoxin Sheng