DataFlow - Gateway Connection Not Detecting automatically

[ptoms]

I am an admin to an enterprise gateway.
We have created an ODBC gateway connection, and, when creating a dataflow using the ODBC connector, when the DSN name is input the gateway connection is not detected automatically. 

Expected Behaviour - Once the DSN is input, the gateway connection, username and password are automatically populated. 
@Anonymous. 

[Anonymous]

Dear MS Team,

Please help us with this issue. We have multiple of developer unable to resume their developemendue to this.

All have sufficient access to use the Gateway connection, however the Gateway is not detected when creating the Dataflow. OP and I as Gateway Admins too are seeing same behaviour  

[Anonymous]

I believe the connection string is case sensitive

[Anonymous]

@Anonymous Yes, we are using the correct cases. Still the issue persists

[Ramesh10]

Hello Support Team, Any updates on this issue?

[Anonymous]

Hi,
@Anonymous 
@v-cazheng-msft 

Could you please help us here?

[Anonymous]

Hi @ptoms ,

This has been determined internally to be an unknown feature limitation.

For now the work around would be to either write out a full connection string (eg. `driver={foo};server=svr;schema=ignored`), or include your wanted schema value as part of the DSN.

Best Regards,
Community Support Team _ Caitlyn