Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Power BI Service - On-Premises Gateway @ Amazon EC2 & Amazon RDS PostgreSQL

Hello, I've been trying to setup a test Power BI Service environment to test if this is a right product for our organization. The actual data resides in Amazon RDS PostgreSQL relational database....

Need Help

Tips and Tricks

Anonymous
5 years ago
Thanks for the reply, I've read that one before, and if one has read that it does not really give help to the actual Power BI Service connection in this particular connection, and the correct syntax for ODBC connection, which is the cause here.

I can reveal the solution here, as we found in-house today:

Remember to put correct ODBC syntax in the connection string:
Driver={PostgreSQL Unicode};Server=amazonaddress.rds.amazonaws.com;Port=32535;Database=YourPostgresDataBase;sslmode=require;