Forum Discussion
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...
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.
This a GREAT solution and gets around published services showing the local time for refreshing. But I have an issue where it sometimes gives an error "DataFormat.Error: We couldn't parse the input provided as a DateTime value." when trying to convert to time/date. This is for Chicago, Illinois, USA where we have daylight savings time. I notice other locations do not have that issue. Is there an extra step we need to add to get around the DST issue?