topic Re: Scheduled refresh in Service

Scheduled refresh

Anonymous — Tue, 24 May 2022 15:24:43 GMT

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

Re: Scheduled refresh

Anonymous — Tue, 24 May 2022 15:46:58 GMT

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

Re: Scheduled refresh

edhans — Tue, 24 May 2022 15:54:01 GMT

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

Re: Scheduled refresh

Anonymous — Tue, 24 May 2022 15:58:44 GMT

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

Re: Scheduled refresh

Anonymous — Tue, 24 May 2022 15:59:40 GMT

This method is not working with scheduled refresh.

Re: Scheduled refresh

edhans — Tue, 24 May 2022 16:57:44 GMT

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.

Re: Scheduled refresh

Anonymous — Thu, 28 Jul 2022 08:46:17 GMT

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