Scheduled refresh

[Anonymous]

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

[edhans]

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

[Anonymous]

This method is not working with scheduled refresh.

[Anonymous]

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

[Anonymous]

This method works only if I refresh it manually but it doesn't work with scheduled refresh.

[edhans · Accepted solution]

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.

[Anonymous]

My table has been set to automatic update however, as stated above, with scheduled refresh it does not work entirely.

When i opened the dashboard it changed the date but the time had been set before my scheduled update.

Before: 22-07-2022 10:23

Scheduled refresh: 28-07-2022 09:00

After: 28-07-2022 07:14