Include time stamp on dataset view in service

[Anonymous]

How would I include a time stamp visual that originates from a dataset that is on an autorefresh schedule q2 hours?  The goal is to display the time the data set was last refreshed.  Thank you

[Greg_Deckler]

Include a column in one of your tables that refreshes of TODAY() or NOW(). This will be updated upon refresh.

[Anonymous]

Thanks.  Did that and used NOW().  Looks as expected in desk top, example 12:25 local time which matched, but service is displaying time as 5:18

[Greg_Deckler · Accepted solution]

Yeah, that's because of the time zone offset. Apparently the time zone of the service is +5 hours ahead or -7 hours from your time zone. You can fix that by adding or subtracting hours.

Measure 27 = NOW() + .0416666666667 * (1)

Just adjust the + sign and the 1 as needed.

[Greg_Deckler]

Created a Quick Measure for this:

https://community.powerbi.com/t5/Quick-Measures-Gallery/TIMEADD/m-p/585280#M278