Power BI

Completed

PostgreSql Datasource for Enterprise Gateway

Vote (179)

Greg Scott on 07 Jan 2016 01:29:58

Any chance of connecting to PostgreSQL data Source with the new Enterprise Gateway, we can with the Personal Gateway, but really need the Enterprise Gateway

Administrator on 05 May 2017 05:39:03

Hello, I'm excited to mark this feature as "completed". PostgreSQL support was added to the On-premises data gateway in the latest release. Make sure to update your gateway and try it out! Thanks, Dimah The Power BI Gateway team

Comments (19)

Comments (19)

9570cd9e 60d3-4893-ac7d-3eba750ca752 on 05 Jul 2020 22:39:35

RE: PostgreSql Datasource for Enterprise Gateway

Great News - thanks

61c3bf22 62cd-4cad-b634-b43e86cca5e6 on 05 Jul 2020 22:37:07

RE: PostgreSql Datasource for Enterprise Gateway

'@tony, Ezequiel are you still having issues connecting with the personal gateway?

fc8b0b0c 8c8e-4f4e-9f72-8d70d8d8d74c on 05 Jul 2020 22:36:29

RE: PostgreSql Datasource for Enterprise Gateway

yeah, tried ODBC. kept yelling:
"ODBC: The connection string is invalid. The connection property 'uid' can only be provided using credentials."

Connection String:
Driver={PostgreSQL UNICODE};Server=myserver;port=5432;Database=postgres; Uid***;Pwd=***];

tried it w/o uid still same error. please fix.