Dynamic Failure Messages from 1 Activity

I haven't test it out yet, I will test and let you know here if this solution worked.

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

Yes, this can be handled in Microsoft Fabric without creating separate failure logic for all 150+ activities. Since your pipeline is continuously growing, the better approach would be to use a centralized failure-handling activity and connect all Notebook, Semantic Model, and Power BI activities through the “On Failure” path. Inside the common handler, you can use dynamic expressions to capture details such as the failed activity name, error message, status, and activity type instead of hardcoding values for each activity. This makes the solution much easier to maintain and scale.

For a more enterprise-level design, you can also consider a metadata-driven approach using Lookup + For Each activity, where activities are managed from a config table or JSON file instead of manually maintaining hundreds of pipeline activities. Fabric currently does not provide a fully automatic global error handler, but the above approach is the most scalable and commonly used pattern for centralized monitoring and dynamic failure logging.

Refer these links:
1. https://learn.microsoft.com/en-gb/azure/data-factory/tutorial-pipeline-failure-error-handling? 
2. https://learn.microsoft.com/en-gb/azure/data-factory/control-flow-expression-language-functions? 
3. https://learn.microsoft.com/en-gb/fabric/data-factory/pipeline-overview? 

Hope this helps. If you have any questions regarding this, please feel free to reach out us. We will be happy to help.

That Failure activity will give me a notification on my email / Teams? - my believe is, its just notify you in MS Fabric and I / we don't check notifications inside the Fabric every day.