Azure sql Mirror Database in fabric Update event

[DiKi-I]

is it possible to trigger pipelines/notebook automatically in fabric when the mirror db updates? I'm looking for some kind of trigger that will help me with this job? Could some please help?

[v-tsaipranay]

Hi @DiKi-I ,

Thank you for reaching out to the Microsoft fabric community forum.

At present, Microsoft Fabric does not offer native support for automatic triggers based on mirrored database updates. Its event-driven features, such as Data Activator and event triggers, are intended to react to file-level changes in OneLake or Azure Blob Storage, rather than database-level changes from mirroring.

There are a few alternative approaches you can consider:

• Utilize Power Automate or other monitoring tools to detect updates in the Azure SQL Database and then trigger Fabric pipelines or notebooks using REST APIs.
• Set up pipelines with incremental logic to handle new data on a scheduled basis.

For additional information please refer to the following documentation: Build Event-Driven Data Pipelines in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

If real-time automation from mirrored databases is essential for your process, you can submit a feature request in the Microsoft Fabric Ideas Forum using the following link: Fabric Ideas - Microsoft Fabric Community

Hope this helps, please feel free to reach out for any further questions.

Thank you.

[v-tsaipranay]

Hi @DiKi-I ,

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

Thank you.

[v-tsaipranay]

Hi @DiKi-I ,

Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.

For any further discussions or questions, please reach out to fabric community forum.

Thank you.