Show refresh date and time in DirectQuery when using Page refresh

[DM_EU]

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

[truptis · Accepted solution]

@DM_EU 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]

@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]

@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.

[DM_EU]

Thank you very much for your help truptis 🙂

Have a nice day

[truptis]

Hi @DM_EU , 

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. 

[DM_EU]

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