Start PowerBI and select "Get data" from the top ribbon, and then select "PostgreSQL Database" under the "Database" category of the "Get data" menu. Click "Connect."
Enter the "server" name (db.bit.io) and your database name, which can be found in the "Connect" menu of your database page on bit.io. Click "OK."
When prompted, enter your bit.io username and password. You can now work with your data on PowerBI.
Alternately, if you've set up an ODBC connection (see Connecting via ODBC ), you can select "ODBC" from the connect menu, select the connection you previously set up, and enter your username and password to connect to your bit.io database.
Updated 5 months ago