Forum Discussion
How to connect to an Azure SQL Read Only Replica from Fabric?
I’m new to Microsoft Fabric and I’m reading data from an Azure SQL database that has a read-only replica using dataflow gen2. I want Fabric to always read from the read-only replica instead of the primary database.
I tried adding ApplicationIntent=ReadOnly to the server name, but Fabric doesn’t seem to accept it. I also watched a Guy in a Cube video where it was mentioned that Enable Failover Support in the advanced options would connect to the read-only replica.
Does enabling Failover Support always route reads to the read-only replica, or is this option meant for something else? What's the best way to ensure I always connect to th replica for loading the data into Fabric?
Thanks for your time!
Hi joesam123 ,
Thank you for reaching out to the Microsoft Fabric Community. The Failover Support option in Fabric is designed for high availability and does not force connections to a read only replica. When the primary is unavailable, connections can fail over, but this isn’t the same as read routing.
To connect to a read only replica in Azure SQL, you typically use ApplicationIntent=ReadOnly, but Fabric Dataflow Gen2 doesn’t currently support this parameter, so adding it has no effect. If you want Fabric to always read from the replica, you should connect directly to the read only endpoint, such as the secondary listener. Keep in mind that replicas might lag slightly behind the primary, so the data may not always be completely current.
If I’ve misunderstood anything from your point of view, please let me know.
Regards,
Yugandhar.
3 Replies
Hi joesam123 ,
Thank you for reaching out to the Microsoft Fabric Community. The Failover Support option in Fabric is designed for high availability and does not force connections to a read only replica. When the primary is unavailable, connections can fail over, but this isn’t the same as read routing.
To connect to a read only replica in Azure SQL, you typically use ApplicationIntent=ReadOnly, but Fabric Dataflow Gen2 doesn’t currently support this parameter, so adding it has no effect. If you want Fabric to always read from the replica, you should connect directly to the read only endpoint, such as the secondary listener. Keep in mind that replicas might lag slightly behind the primary, so the data may not always be completely current.
If I’ve misunderstood anything from your point of view, please let me know.
Regards,
Yugandhar.Hi joesam123 ,
Could you please let us know if your issue has been resolved, or if you need any additional information from us. We’ll be happy to help.
Thank you.
Hi joesam123 ,
May I know if the issue has been resolved? If you need any additional information or clarification, please let us know.
Thank you.