At FabCon 2026, we’re excited to announce the Public Preview of Microsoft Fabric Mirroring integration for Azure Database for MySQL. This integration makes it easier than ever to analyze MySQL operational data using Fabric’s unified analytics platform, without building or maintaining ETL pipelines.
This milestone brings near real-time data replication from Azure Database for MySQL into Microsoft Fabric OneLake, unlocking powerful analytics, reporting, and AI scenarios while keeping transactional workloads isolated and performant.
Why Fabric integration for Azure Database for MySQL?
MySQL is widely used to power business‑critical applications, but operational databases aren’t optimized for analytics. Traditionally, teams rely on complex ETL pipelines, custom connectors, or batch exports — adding cost, latency, and operational overhead. With Fabric integration, Azure Database for MySQL now connects directly to Microsoft Fabric, enabling:
-
Zero‑ETL analytics on MySQL operational data
-
Near real-time synchronization into OneLake
-
Analytics‑ready open formats for BI, data engineering, and AI
-
A unified experience across Power BI, Lakehouse, Warehousing, and notebooks
All without impacting your production workloads.
What’s new in the Public Preview?
The Public Preview introduces a first‑class integration between Azure Database for MySQL and Microsoft Fabric, designed for simplicity and scale. It introduces a solid set of core operational and enterprise‑readiness capabilities, enabling end-users to confidently get started and scale their analytics scenarios.
- Core replication operations
-
Start, monitor, and stop replication directly from the integrated experience
-
Support for both initial data load and continuous change data capture (CDC) to keep data in sync with minimal latency.
-
- Network and security
-
Firewall and gateway support, enabling replication from secured MySQL environments.
-
Support for Azure Database for MySQL servers configured with customer‑managed keys (BYOK), aligning with enterprise security and compliance requirements.
-
- Broader data coverage and troubleshooting
-
Ability to mirror tables containing previously unsupported data types, expanding schema compatibility and reducing onboarding friction.
-
Support for up to 1,000 tables per server, enabling larger and more complex databases to participate in Fabric analytics.
-
Basic error messaging and visibility to help identify replication issues and monitor progress during setup and ongoing operations.
-
What scenarios does it unlock?
With Fabric integration in place, you can now analyze data in Azure Database for MySQL without impacting production, combine it with other data in Fabric for richer reporting, and use Fabric’s built‑in analytics and AI tools to get insights faster. Learn more about exploring replicated data in Fabric in Explore data in your mirrored database using Microsoft Fabric.
How does it work (high level)?
Fabric integration for Azure Database for MySQL follows a simple but powerful pattern:
- Enable and Configure - Enable replication in the Azure portal, then use the Fabric portal to provide connection details and select MySQL tables to mirror.
- Initial snapshot - Fabric takes a bulk snapshot of the selected tables, converts the data to Parquet, and writes it to a Fabric landing zone.
- Continuous change capture - Ongoing inserts, updates, and deletes are captured from MySQL binlogs and continuously written as incremental Parquet files.
- Analytics‑ready in Fabric - The Fabric Replicator processes snapshot and change files and applies them to Delta tables in OneLake, keeping data in sync and ready for analytics.
This design ensures low overhead on the source, while providing fresh data for analytics and AI workloads.
Below is a more detailed workflow illustrating how this works:
Getting started with the Public Preview
To try Fabric integration for Azure Database for MySQL during Public Preview, you’ll need:
- An Azure Database for MySQL instance
- An active Microsoft Fabric capacity (trial or paid)
- Access to a Fabric workspace
Once enabled, you can select the MySQL databases and tables you want to replicate and begin analyzing data in Fabric. For step-by-step tutorial, please refer to - https://learn.microsoft.com/azure/mysql/integration/fabric-mirroring-mysql
Stay Connected
We’re thrilled to share this milestone at FabCon 2026 and can’t wait to see how you use Fabric integration for Azure Database for MySQL to simplify analytics and unlock new insights. We welcome your feedback and invite you to share your experiences or suggestions at AskAzureDBforMySQL@service.microsoft.com
Try the Public Preview, share your feedback, and help shape what’s next. Thank you for choosing Azure Database for MySQL!
Microsoft