Forum Discussion
Scheduled refresh
Hi all,
I have set scheduled refresh for my report and I want to display the last refreshed time/date in the dashboard. Is it possible to display the last refreshed time/date in the dashboard?
Regards,
Arvind
Yes it does. I use it in every single report I write.
Note the refresh time (or data for that matter) will not update on the user's browser unless they refresh it or you have the pages set to auto-reload every once in a while. When you pull up a Power BI report, that data is "static" and does not reflect a new refresh in the background unless you refresh the browser or the report using the icon.
the only way this would not work with a scheduled refresh is if you set the table that creates this to not automatically refresh.
6 Replies
Hi
When your data is refreshed powerquery runs all his queries, so you can run a function to retrieve your current date-time and use it as a stamp.
Here you have an article that demonstrates just that.
https://addendanalytics.com/blog/last-refresh-date-in-power-bi/
Hope it helps
Yes it does. I use it in every single report I write.
Note the refresh time (or data for that matter) will not update on the user's browser unless they refresh it or you have the pages set to auto-reload every once in a while. When you pull up a Power BI report, that data is "static" and does not reflect a new refresh in the background unless you refresh the browser or the report using the icon.
the only way this would not work with a scheduled refresh is if you set the table that creates this to not automatically refresh.
Hi Anonymous - I wrote a blog post about this a while back, including handling daylight savings time if your timezone uses that. Add a Refresh Time Stamp To Your Power BI Reports — ehansalytics