Forum Discussion
Visual
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
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
3 Replies
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/
GuyInACube also has a video on the topic that might help.
https://www.youtube.com/watch?v=oN6mOmEruOQ&ab_channel=GuyinaCube
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
