Forum Discussion
Scheduled refresh
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
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
This method works only if I refresh it manually but it doesn't work with scheduled refresh.
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.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