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.
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.