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.
Add... and choose the Postgres Unicode driver:
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.
Save and you're all done!
Updated 4 months ago