Forum Discussion
Connecting to Azure SQL Managed Instance Read-Only Replica
Hello,
I was wondering if there's a way to connect to a read-only replicate on an Azure SQL Managed Instance via Fabric Dataflow Gen2. I can connect to a read-only replicate using SSMS as shown here https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql , but I'm not sure if there's a way to do it from a Dataflow.
Thanks!
If the ApplicationIntent value is ReadOnly, the connection is routed to a read-only replica.I don't think that attribute is supported by the default SQL database connector
Sql.Database - PowerQuery M | Microsoft Learn
It is also not mentioned for the ODBC connector.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
2 Replies
If the ApplicationIntent value is ReadOnly, the connection is routed to a read-only replica.I don't think that attribute is supported by the default SQL database connector
Sql.Database - PowerQuery M | Microsoft Learn
It is also not mentioned for the ODBC connector.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
Hi gcarvalho
Thank you very much lbendlin for your prompt reply.
This forum is used to discuss Fabric related content.
Since this is a product issue beyond the scope of this forum, I recommend that you post this query on the Azure Data Factory Community Forum.
The following links:
Azure Data Factory - Microsoft Community Hub
If you have any Fabric related questions, please continue to use this forum to contact us!
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
