Hi @umangmistryBO,
Have you tried add a gateway? Connecting to PostgresSQL would need to install a gateway first.
I assume that you already have PostgreSQL client software installed and that you can already connect successfully to the target PostgreSQL database.
Currently there is no document published for PostgresSQL about the connecting steps.But I think it should be similar with the steps for Oracle:
Try this link: https://powerapps.microsoft.com/en-us/blog/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps/
Connecting to Oracle Database from PowerApps, Flow and Logic Apps
Or you may take a reference of the following thread:
PostgreSQL Connection through On-premise Data Gateway
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.
Hope the information above is helpful
Thanks,
K-A-R-L
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
