Forum Discussion

Virtual_Ames's avatar
Virtual_Ames
Microsoft Employee
10 years ago
Solved

Easy consistent Last Refresh Time (your local time zone) solution - no matter how refreshed

If you want to make sure your viewers know how fresh the data in a report is - you may want to have a "Last Refreshed" tile showing.  The challenge is - if you publish from your desktop, you get last...
Show and Tell
Tips and Tricks
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    Virtual_Ames

     

    Thanks for your sharing. That's a awesome idea to indicate a precise refresh time. :)

     

    Just some tips, no need to import the web as a source, the Power Query,also known as "M", has a "DateTimeZone.UtcNow()", you can get UTC time with that function and tweak different timezones based on UTC.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Eric_Zhang

 

Add a custom column in Query Editor. The 8 refers to timezone offset, it always shows the local time of +08:00 timezone.

DateTimeZone.UtcNow()+#duration(0, 8, 0, 0)

 

This works but how do I modify it to reflect daylight savings time? I need the time stamp to be Pacific, but reflect whether we're in standard time or daylight savings time.