error log of SSRS data-driven subscription

[SolomonovAnton]

Hello ! 

I have an SSRS report hosted on Power BI Report Server. The SSRS report has a data-driven subscription that sends an Excel file via email. How can I find a list of email addresses that encountered errors if the data-driven subscription indicates there were issues?

[Anonymous]

Hi, @SolomonovAnton 

Go to the Subscriptions tab in the web portal of Power BI Report Server. Find the status of your data-driven subscription. If there is an error, the status will show the problem.
Detailed error information is logged in the Reporting Service logs. These logs are typically located at:

C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles

Open the relevant log file and search for entries related to your subscription.
You can also query the ExecutionLog3 view in the ReportServer database for details about subscription executions. This view includes columns such as Status and Error, which can help identify issues.

You can check the following links:

Troubleshoot Reporting Services subscriptions and delivery - SQL Server Reporting Services (SSRS) | ...

Monitor Reporting Services subscriptions - SQL Server Reporting Services (SSRS) | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Expiscornovus]

Hi @SolomonovAnton,

Below is an example of a thread where they used the SSRS catalog:

https://community.fabric.microsoft.com/t5/Report-Server/Report-to-extract-failed-subscriptions/m-p/2...

That solution is based on this blog:

https://www.sqlshack.com/ssrs-failed-subscription-alerting/

[SolomonovAnton]

thank you for you answer! unfortunately, I didn't find list of recipients in code presented by link.  field 'Recipients' from code - it is subscription description, but not emails

[aduguid]

Here's a report I use to check the execution log.

https://github.com/SQL-Server-projects/Reporting-Services-examples/blob/master/ServerReports/Executi...

[SolomonovAnton]

thank you for your link! It is realy cool repository !!

but unfortunately I can't answer at my question