Visual

[Anonymous]

Hi all
I want to create a visual that shows the date the dashboard was refreshed. Something like; Latest Update was: 09/092020
Thanks in advance

[Anonymous · Accepted solution]

Hi @Anonymous ,

Create a Blank Query in Query Editor using the below formula.

= #table(type table[Last Refresh Date=datetime], {{DateTime.LocalNow()+#duration(0,2,0,0)}})

https://docs.microsoft.com/en-us/powerquery-m/sharpduration 

"#duration(0,2,0,0)"

This parameter is to add the time difference to the local time. The specific value is based on the time difference between your local time and the UTC time.

Best Regards,

Jay

[jdbuchanan71]

@GuyInACube also has a video on the topic that might help.

https://www.youtube.com/watch?v=oN6mOmEruOQ&ab_channel=GuyinaCube

[amitchandak]

@Anonymous , There is blog around that, see if that can help

https://www.enhansoft.com/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/