On Prem set up

Hi jashfabric 
Thanks for using Fabric Community.

Currently ODBC connection is possible in Dataflow Gen2.

https://learn.microsoft.com/en-us/fabric/data-factory/connector-odbc

Please check the supported types here

https://learn.microsoft.com/en-us/power-query/connectors/odbc#prerequisites

Please check the requirements from the link below:

https://learn.microsoft.com/en-us/power-query/dataflows/using-dataflows-with-on-premises-data

Only standard gateways are supported in Dataflows. Not personal gateways.

Hope this helps. Please let me know if you have any further questions.