topic Re: On Prem set up in Dataflow

On Prem set up

jashfabric — Fri, 03 May 2024 04:46:27 GMT

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.

Re: On Prem set up

Anonymous — Fri, 03 May 2024 05:48:44 GMT

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.

Re: On Prem set up

jashfabric — Fri, 03 May 2024 08:45:59 GMT

Thanks for the details Anonymous

Will the personal gateways be supported in the future?

Thanks for your support

Re: On Prem set up

Anonymous — Mon, 06 May 2024 10:52:50 GMT

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