Forum Discussion
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, when I go to Power BI Service, I need to know when exactly the data has been refreshed.
Is it possible?
Thank you
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.
6 Replies
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 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??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.
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.
