Unleashing Data for OneLake with Mirroring in Microsoft Fabric

Learn how to replicate your database to Microsoft Fabric using Mirroring! Patrick walks you through how you can do this with Azure SQL Database and CosmosDB and join across the two.

What is Mirroring in Fabric?

Mirroring Azure SQL Database (Preview)

Mirroring Azure Cosmos DB (Preview)


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#MicrosoftFabric #Mirroring #GuyInACube

[wojciechjaniszewski]

Hi Patric, Thanking you for the content as always. Would you know whether Mirrored Azure Databricks Catalog would replicate data or just simply creates delta table shortcuts?

[pjennings]

Are there any plans for this to work with temporal tables? This was listed as a limitation in the initial docs, but I haven't been able to find any further information since then.

[guimatheus]

Is this the same or similar as creating a Follower Database from Azure Data Explorer?

[juliebarnet]

Q: is the Azure Managed Instance supported yet or is it still just Azure DB?

[rubenravna]

Q: i currently have an azure sql db <-> Azure analysis service setup. Since I’m soon migrating to Fabric F SKU I am curios about using semantic model in Fabric instead of AAS. Can I use a mirrored version of my sql db as source for this semantic version or is it crucial to have dedicated imports into Fabric lakehouse? I have a couple of tables that are quite big and partitions is used for performance and compression.

[padfootanimagus]

Can't wait until on prem sql server is supported