Forum Discussion
On Prem set up
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.
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.
3 Replies
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.
Thanks for the details Anonymous
Will the personal gateways be supported in the future?
Thanks for your support
Hi jashfabric
There is no information regarding this yet. I will keep you posted regarding the updates.
Thanks
