Forum Discussion
Solved
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 h...
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
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