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
Icon for Community Champion rankCommunity 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

It did not work. It's giving me an error but doesn't tell me what, and the visualization is (Blank). Thanks.