cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
achude
Helper I
Helper I

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.
1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @achude,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @achude,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Amit_PowerBIPro
Helper III
Helper III

HI @achude,

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors