name_is_too_short,
I'd just like to clarify in case someone else comes along and has a small bit of trouble following.
Let's say your Postgres Connection URL is...
postgresql://user1:123456789@XYZ123.retooldb.com/production
The info entered into Power BI would be as follows:
Server: XYZ123.retooldb.com
Database: production
User: user1
Password: 123456789
Data Source Settings:
Encrypt connections - off
OP's post solution was spot on, I just stumbled a bit following it and thought I'd add in case others did as well.
Thanks again for the solution!!
-Jonathan