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.

truptis's avatar
truptis
Icon for Community Champion rankCommunity Champion
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you very much for your help truptis 🙂

    Have a nice day

  • Pooja_Pandya's avatar
    Pooja_Pandya
    Icon for Helper I rankHelper 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
      Icon for Community Champion rankCommunity 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.