Forum Discussion
PBI Report Server Schedule refresh
Hi MM_955,
In Power BI Report Server, the ExecutionLog3 view in the ReportServer database can indicate when a refresh request begins, such as when RequestType is set to 'Refresh Cache', but it does not always clearly show when the refresh completes successfully. This can make it challenging to use execution logs alone to identify the last successful refresh. An easier method is to include a simple query in the dataset like select getdate() AS LastRefreshTime, which records the current timestamp during the refresh. This value can then be shown in the report so users know when the data was last refreshed successfully..
Thank you.
Hi MM_955,
The easiest way to do this is to make a calculated table in your model with one column, and that column be the NOW() M function.
Then when your model refreshes, this table will be re-evaluated and display the time that the model was refreshed.
I would avoid trying to dig through the metadata database, that's never a fun thing to dig through in my experience.