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.

886886

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

900900

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." Click "test" to confirm that the connection has been established successfully.

11721172

Hit Save and you're all done!


What’s Next

Use this ODBC connection to connect to bit.io using PowerBI.

Did this page help you?