ODBC

One way to connect to bit.io when you're on Windows is via ODBC.

First, download the PostgreSQL ODBC driver for the latest version of Postgres. The drivers can be found here

Unzip it, and install it via the included MSI file.

Open up the ODBC Data Source application on your Windows Machine, and add a new source, which will be available for use by other applications such as Connecting via PowerBI.

Click Add... and choose the Postgres Unicode driver:

Click Finish.

Click "Configure" and add your username, password, hostname (Server), and database name from your database page "Connect" menu. Make sure to change "SSL Mode" to "prefer" or "require" (or, better yet, "verify-full") Click "test" to confirm that the connection has been established successfully.

Hit Save and you're all done!