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
Community Champion
4 years ago

Hi Anonymous , 

If it is a directQuery then create this measure:

Last Refresh date = UTCNOW()

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI truptis,

     

    It almost works but there is one hour of difference. How can I remove one hour from this measure to be accurate with my timezone?

     

    Thank you