Reading from SQL Managed Instance Read Only Replica via 'On Premise' SQL Data Gateway

Hi ,  BrianDrought 

Accoridng to your description and the shared link is trying to connect to the Azure Sql server Read-Only Replica.

You have selected the “Enable SQL Server Failover support”  options in the dataflow sql server connector and add the connection string "ApplicationIntent=ReadOnly". And you are using the on-premise data gateway to connect your Azure sql server then you found that it hit the Read-Write node instead of the Read-Only Node .

As searched , there is the document about this configure the  connect to the Azure Sql server Read-Only Replica, you can refer to :
Refreshing data in Power BI from SQL Server Read-o... - Microsoft Fabric Community

And as searched in the internal PG reply , the PG teams said that :
Dataflows always write to a blob store during refresh so at that point there is no design today to maintain the ApplicationIntent = ReadOnly. So we also connect to Sql without application intent and thus returning READ_WRITE in the Dataflow as also seen in the fiddler.

 So, you can try to check whether we hit the read-only node when we view the data in Dataflow. And when using the gateway to refresh, hit the read-write node?

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly