Forum Discussion

mircea's avatar
mircea
Helper I
3 years ago
Solved

How to get notified or identify report refresh errors?

Hello,   Is there any way to query Report Server database and find information about various report refresh errors? I would like to use SQL to get a list of errors sorted by date. Then I can write...
Need Assistance
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi mircea ,

    Whenever a Power BI report is rendered, or a schedule refresh plan is executed, new entries are added to the Execution Log in the database. These entries are available in the ExecutionLog3 view within the report server catalog database.

     

    The log files which hold information about scheduled refresh are the RSPowerBI_ logs. They are located in the LogFiles folder of your report server installation location.

    C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPowerBI_*.log

    For more details, you can read related document: Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi mircea ,

Whenever a Power BI report is rendered, or a schedule refresh plan is executed, new entries are added to the Execution Log in the database. These entries are available in the ExecutionLog3 view within the report server catalog database.

 

The log files which hold information about scheduled refresh are the RSPowerBI_ logs. They are located in the LogFiles folder of your report server installation location.

C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPowerBI_*.log

For more details, you can read related document: Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.