Forum Discussion
Azure sql Mirror Database in fabric Update event
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.