Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Show refresh date and time in DirectQuery when using Page refresh

Hello,   I am using Page Refresh in DirectQuery mode and I would like to show on the report the last time the dataset has been refreshed. For example, if I put the page refresh every 10 minutes, wh...
Need Help
  • truptis's avatar
    truptis
    4 years ago

    Anonymous if UTCNOW isn't giving accurate results, then try using this:
    Last refresh = NOW()

     

    Please mark this as a solution & hit the thumbs up if it helps you. Thanks.

Pooja_Pandya's avatar
Pooja_Pandya
Helper I
2 years ago

truptis UTCNOW() or NOW() doesn't work for me. 
NOW() correctly works in PBI Desktop but changes time in PBI Service. UTCNOW() shows UTC time. Can you please suggest any other idea?? 

truptis's avatar
truptis
Community Champion
2 years ago

Pooja_Pandya - try using Now()-8/24

 

this might work

 

please hit a thumbs up and mark it as a solution if it helps you. Thanks.