Solved: How to display data source refresh time ?

clarawang_12 · ‎01-08-2023

Dear Community,

The data source of my report is on Sharepoint Folder, and it is scheduled to be refresh on 1 AM UTC.

I have tried to use formula "Latest Refresh: "&UTCNOW()&" UTC", but it is showing "NOW" time stamps, instead of data source refresh time.

Is there a way that can display latest data source refersh time stamp on my report? Thanks.

Best regards,

Clara

Greg_Deckler · ‎01-08-2023

@clarawang_12 I think the Service kind of does that by default now. But, if you put that formula into a Calculated Column (not a measure) then it should be the time of the last refresh as the calculated column only gets calcuated at the time of data refresh.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Greg_Deckler · ‎01-08-2023

@clarawang_12 I think the Service kind of does that by default now. But, if you put that formula into a Calculated Column (not a measure) then it should be the time of the last refresh as the calculated column only gets calcuated at the time of data refresh.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...