Time difference between Desktop and service

[Anonymous]

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.

[v-shex-msft · Accepted solution]

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

[amikm]

HI @Anonymous,

Please check this post from Reza Rad, it might solve your issue
http://www.radacad.com/solving-dax-time-zone-issue-in-power-bi