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.
Hi, got it and tks!
And could you recommend a VM link or VM software name to me? which fit for WIN10 OS and Power BI Gateway...
tks!
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!