Forum Discussion

jimbob2285's avatar
jimbob2285
Icon for Advocate IV rankAdvocate IV
3 years ago

Last refresh time not correct between data set and report, both in the service

I've added a last refresh date & time to a report but it seems to be running an hour and 2 minutes behind???   while I'm fully aware that the time in the desktop app uses my local PC time and that ...
Need Help
arcejames's avatar
arcejames
Frequent Visitor
3 years ago

try this function in Power Query / Blank query :

DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),-6,0) and then convert that column to Table. The variable -6 can be changed based on the prefered Time Zone.

and let me know if that works

  • jimbob2285's avatar
    jimbob2285
    Icon for Advocate IV rankAdvocate IV
    3 years ago

    Hi arcejames

     

    but the variance isn't between desktop and the service, it;s between the workspace and the report, both in the service

     

    Cheers

    Jim