Bertverbeek4PS / bc2adls

Exporting data from Dynamics 365 Business Central to Azure data lake storage or MS Fabric lakehouse
MIT License
49 stars 20 forks source link

Microsoft Fabric - Notification on failure notebook #26

Closed Arthurvdv closed 1 year ago

Arthurvdv commented 1 year ago

Is there a best pratice on setting up a notification when a execution of a scheduled Notebook failures?

I didn't test thorough a modification on the CopyBusinessCentral notebook, and that's on me 😳 Secondly I was surprised that the executing times where improved, again on me not to investigate what the cause of this was. This is a proof-of-concept setup, so no harm done, but got me thinking: Is there a way to get notified when the execution of a notebook has failed?

image image

Bertverbeek4PS commented 1 year ago

Well you can do that in a pipeline. If you create a pipeline and add the notebook. On failure you can send a teams message or an outlook message: image Then in the settings tab you can define everything: And the notebook output you can define in your body by adding a dynamic context. image

That pipeline you can schedule.

Arthurvdv commented 1 year ago

This is exactly what I was searching for, thanks!