title: Is it possible to specify ApplicationIntent = ReadOnly for Azure Data Factory connecting to on-premise SQL Server?
body: <p>The goal is for Data Factory to connect to my on premise SQL Server Availability group and run a stored procedure to generate data that is then copied to Azure SQL. So far it works, but i would love to have this SP run on a secondary (ReadOnly) node. </p>
  
  <p>This (reading data from secondary node via ApplicationIntent=ReadOnly) works when used in our own applications, but for some reason when i add it to connection string in Azure Data Factory it is silently ignored (SP gets executed on primary node).</p>
  
  <p>Has anyone tried this with success or is it known that its not supported?</p>