Visibility to Sub-Report Failures

Hi aaroncampeau,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Here are the suggestions:

Error Flag in Main Report: Modify the main SSRS report to include an error flag or status from each sub-report, so Power Automate can detect issues by checking this flag after report generation.

Excel Tab Check in Power Automate : Add a step in the flow to list and validate the worksheet names in the generated Excel file; if any expected tab is missing, trigger a notification or retry.

Script-Based Excel Validation : Use a PowerShell script or Azure Function to inspect Excel files for missing tabs or rendering errors, then pass the result to Power Automate for further action.

Database Logging from Sub-reports : Have sub-reports write their execution status to a central SQL table, which the flow can query to check for failures before sending final output.

Status Tab in Reports : Include a dedicated tab in each report summarizing sub-report success or failure, which Power Automate can scan for a quick health check.

If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.

Thank you & regards,
Prasanna Kumar