Forum Discussion

MM_955's avatar
MM_955
New Member
5 months ago
Solved

PBI Report Server Schedule refresh

I am using Power BI Report Server with scheduled dataset refresh enabled for my reports. I would like to display the last successful data refresh date and time directly in a Power BI dashboard hosted...
Report Server
  • v-saisrao-msft's avatar
    v-saisrao-msft
    5 months ago

    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.

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
5 months ago

Hi MM_955,

Thank you tayloramy, for your insights,

In Power BI Report Server, when a scheduled refresh plan runs, it creates entries in the ExecutionLog3 view of the ReportServer database. As noted in Microsoft documentation, a RequestType of Refresh Cache shows that a scheduled refresh plan was executed. The refresh process may also record ItemAction values like DataRefresh and SaveToCatalog, which indicate data refreshes and saving the updated model to the catalog. These log entries can be used to track refresh activity and execution times.

Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

Use ExecutionLog and the ExecutionLog3 view in Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn

 

Thank you