Forum Discussion
ODBC Gateway Setup fail!
You need to successfully connect to your data source via ODBC on the gateway VM before you can proceed to create the connection on the gateway. The ODBC system dialog has a "Test" option. You can use that, or install a database client on the gateway VM for the test.
Here are the recommendations
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
Hint: these are on the very low end of the scale. Generally you want as much power and memory and fast disks as you can get.
I have that gateway...
And successfully used on connecting public folder, server database(sql server)...
My PBI have a lot of reports and daily scheduled refresh them by the gateway in a year...
Just failed creation ODBC gateway... BUT, the ODBC successful connection data to PBI desktop...
BTW, my source database is iBM AS400, fyi..
tks..
use the ODBC control panel on the gateway (not on your PC) to validate that you can reach the data source from the gateway through ODBC.
Doesn't matter if it works on the PC. It needs to work on the gateway.
Dear,Fail1Fail2Fail detailODBC setup has follow System DSN
pls see the pics...
tks!
may be you mean setup on the gateway,,, pls see the pics,,, since my gateway installed in a server and ODBC not in it...
so , it looks i have to use personal gateway or install ODBC on it...
tks.gateway status okODBC not install in that server