Forum Discussion
PostgreSQL connection through On-premise Data Gateway
Hello,
for ODBC connection to postgres you need to get installed ODBC driver for postgres;i am using PostgresSQL Unicode(x64).
After that you have 2 options:
1) create user DSN via ODBC data source administrator (C:\Windows\System32\odbcad32.exe). In that case the connection string for ODBC data source is "dsn=dsn_name" where dsn_name represents the user dsn created via tool above
2) alternative option for connection string is: driver={PostgreSQL Unicode(x64)};server=server_name;port=5432;database=db_name
where server_name represents a server name or its IP, db_name is name of database.
For using on-premise gateway you need to use ODBC connection to postgress on power bi desktop. Then you need to configure data sources using ODBC the same way on on-premise gateway.
I am using above approach for connection to multiple different postgres databases.
I hope it helps.
Kind regards
M
Hi martina,
All is working fine now, I've been able to have my on-premise connector up and running without issues and after that, the problem with ODBC connector was related with the ODBC configuration in my Power BI Desktop, I wrote a DataSourceName when not necessary.
Thanks again for your support,
Kind regards.
juanca can you please explain the following in more details "was related with the ODBC configuration in my Power BI Desktop, I wrote a DataSourceName when not necessary."? I'm also stuck where my on-premises gateway + odbc/postgresql works fine, but the dataset published cannot see it (data gateway option greyed out).
Hi,
data source in power bi desktop must match to data source created on a gateway. In other words DSN name used in ODBC connection must be the same (on desktop as well as gateway).