Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

ODBC Gateway Setup fail!

Hi,  1) the base info : PBI - Pro, Gateway - On-premises 2) I learned about the community's thread on this issue https://community.powerbi.com/t5/Service/Can-t-connect-ODBC-datasource-to-gateway/m-...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    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.

lbendlin's avatar
lbendlin
Super User
6 years ago

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.

rbeekman's avatar
rbeekman
New Member
3 years ago

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.