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.

MM_955's avatar
MM_955
New Member
5 months ago

Thank you for your response, I did checked the executionlog3, this table captures when refresh starts but not showing it is completed successfully or not. basically I need to capture the time it was completed. if this complicated approach what is the alternative ? i need to show last refresh date and time (successfull) in the dashboard. 

 

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

HI MM_955,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

 

Thank you.