On Prem set up

[jashfabric]

Hey all

How to set up a personal On Premise gateway in Dataflows? I have an ODBC driver in my computer. I want to use this and get my data into the Fabric Lakehouse.

Any help is appreciated.

[v-nikhilan-msft · Accepted solution]

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.

[jashfabric]

Thanks for the details @v-nikhilan-msft 

Will the personal gateways be supported in the future?

Thanks for your support

[v-nikhilan-msft]

Hi @jashfabric 
There is no information regarding this yet. I will keep you posted regarding the updates.
Thanks