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 database credentials, but I cannot link the data source with the gateway to schedule automatic updates.
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!
13 Replies
- lbendlin
Super User
please provide more details. Did you install the PostGreSQL driver (npgsql) on all gateway cluster members? Did you test the connection? Are you using the same dsn on all machines and in your report?
Yes, driver installed on all machines and connection created on the gateway. But when I go to the semantic model settings it says "Not configured correctly".
I'm going to validate this dsn point, I don't remember if the server name is the same as the one on my machine.
sergej_ogMaybe additional one from my side.
Don't forget to install the ODBC driver on all your gateway machines.
Setup is working for me:Install these components and try to establish a conncetion to your source.
Maybe firewall-rule is required.
RegardsHello, I already have the odbc driver installed on the server, where the gateway is and on my machine. Rules released on the firewall too.- sergej_og
Nice,
- and you have created a working connection to your source from your gateway vm?
- and you have created the same connection in your gateway (in Service)?
Regards
