Forum Discussion
Solved
Gateway Appears in settings as Not Configured Correctly
Hey guys! I have a connection via odbc from power bi to Postgresql. I installed the gateway on the server with access to the database. I created the connection in power bi services with the databa...
The provocation given about using dsn made me understand the logic and find the solution. The odbc settings on both the server and the desktop were correct, but on the power bi desktop I used a connection string setting the internal IP and this caused the service not to find the gateway. To solve this, simply select the configured system dsn and do not fill in the connection string field, as the service connection always looked for the dsn and no longer for the ip.
Best Regards!
1.Yes, I have an active connection and I have a dash created. (In fact, for testing I have a gateway installed on the desktop that works normally).
Could this error be due to using different IPs on the local connection and the server connection?-Desktop Connection
Internal IP configured in the desktop odbc driver.
Desktop Conection
-Service Connection
External IP configured in the server's odbc driver.
lbendlin
Super User
Super Userany particular reason for not using a dsn ?
- lbendlin
dsn (data source name) is a methodology to configure ODBC connections more conveniently, via the
control panel. It allows you to specify all the details, and to test the connection.
No, I don't think I have any knowledge about it. Is dsn PostgreSQL30?Ah yes, I configured the information in the odbc desktop and server, but I created the user dsn, I will try with the system dsn.The provocation given about using dsn made me understand the logic and find the solution. The odbc settings on both the server and the desktop were correct, but on the power bi desktop I used a connection string setting the internal IP and this caused the service not to find the gateway. To solve this, simply select the configured system dsn and do not fill in the connection string field, as the service connection always looked for the dsn and no longer for the ip.
Best Regards!