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.
No , cannot , that's why I post this issue for help....!
And.. I can connect data /and SQL data through ODBC to PBI desktop , it's successfully...
JUST Gateway setup datasource for refresh 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..
If it were only that easy. I added a MySQL ODBC dsn to my gateway and an MSSQL one. Both dsn's work fine from my laptop PBI desktop works fine with them. But in the cloud PBI keeps saying nog connection can be made tot the gateway. Being untrue, because teh MySQL works fine.
Also tried to setup the connection directly tot SQL server from PBI desktop... no success there either.
