Forum Discussion
Locally installed ODBC driver
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.
Hi stuartbisset
First you would need to install an On-Premises Gateway.
Install an on-premises data gateway | Microsoft Learn
After creating On-Prem gateway, then you can connect this gateway in Fabric.
Hope this helps. Please let me know if you have any further questions.
Many thanks for your response. I believe I have a personal gateway installed correctly which seems to be online:
I also managed to create a connection (though I'm not sure if this is necessary or not?):
But the real trouble begins when I try a dataflow gen 2, using the ODBC connector:
As you can see above:
1. I have guessed the connection string to be "dsn=Blackford Hubspot ODBC".
2. "Create new connection" is the only option i have in the drop down list for 'connection'
3. "(none)" is the only option I have for 'Data Gateway' but I know this should be pointing to my personal mode gateway.
Just can't seem to get this ODBC part working. Any further help, again, very much appreciated.
Many thanks
Stuart
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.