Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Displaying Last Refresh Time in PST

Hi, after publishing my PBI report to the web, the Last Refresh = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}}) time stamp in PBI service is showing UTC time (which is 8 hrs ahead...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    This is what I ended up doing.

    I used the original code: #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})

    Then I created a measure: Last Refresh_PST = MIN('Last Refresh'[LastRefresh])-7/24

    That seemed to work after I published to PBI service.

    Thanks!

     

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

if you are sure in -8 hours offset try to use

DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -8)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

This is what I ended up doing.

I used the original code: #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})

Then I created a measure: Last Refresh_PST = MIN('Last Refresh'[LastRefresh])-7/24

That seemed to work after I published to PBI service.

Thanks!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

    Thanks for sharing your solution. Could you please mark your post as Answered? It will help others in the community find this solution easily if they face the same problem with you. Thank you.

    Best Regards

    Rena