Connecting to Azure SQL Managed Instance Read-Only Replica

[gcarvalho]

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!

[Anonymous]

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.

[lbendlin · Accepted solution]

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