A short blog post about an issue with Fabric Mirroring (with Azure SQL DB as the source) that I’ve managed to run into, twice. I’ve set up mirroring by creating a connection using a service principal and this principal has the proper permissions on the source database. Configuring the replication was without issues, and the replication status went from “starting” to “running”. However, no rows were being copied. The tables were all listed in the monitoring pane, but the counters of “rows replicated” remained at zero. There were no errors in the logs (in OneLake) and nothing suspicious was mentioned in the monitoring.
So what was going on? Turns out, I forgot to give the managed identity of the Azure SQL DB server permissions on the workspace (or on the mirrored db itself). Once I added the managed identity to the workspace as a contributor), replication started working!
------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
