Power Platform Community Forum Thread Details

Trying connect to Postgres DB

Steps:

Postgres ODBC driver ("psqlODBC" )– Installed.
Tested the DB connection – worked.
When configured the connection in ”Power Automate Desktop” (PAD) added a query to pull data from “tblCustomer”– it is not working. Erring out as “connection string isn’t valid”. Looks like PAD is not accepting the ODBC. (provider = MSDASQL)
In PAD - The Only provider for ODBC is "Microsoft OLEDB Providers for ODBC Drivers".
Even though "psqlODBC" driver was installed could not find in the Provider list.

Any help would be appreciated.

Categories: