Skip to main content

Connect to PowerBI using Postgres Proxy

On this page, you'll learn how to connect PowerBI to data.world using Postgres Proxy.

Note

Before you connect PowerBI, make sure you have access to the dataset you want to connect, as well as your data.world Read/Write API key, which you can find in the Advanced tab of your profile settings.

Follow these steps to connect PowerBI to data.world:

  1. In PowerBI, navigate to Get Data.

    postgres_proxy_PBI_1.png

  2. Select PostgreSQL database:

    postgres_proxy_PBI_2.png

  3. On the PostgreSQL database, enter the following values:

    Table 1.

    Item

    Details

    Server

    postgres.data.world:5432

    Database

    The organization and dataset in <organization/dataset> format. You can find these values in the subdirectory/second half of your dataset's URL. For https://data.world/ddw-doccorp/mydataset, you would enter ddw-doccorp/mydataset .

    Data Connectivity Mode

    DirectQuery



    postgres_proxy_PBI_3.png

  4. Select OK, then enter your data.world username in the User name field, followed by your Read/Write API token for the password. Click Connect.

    postgres_proxy_PBI_4.png

  5. Power BI displays the tables you can bring in. Select your desired tables, then click Load.

Testing and troubleshooting connection issues

Once you have connected PowerBI to data.world, Postgres Proxy maintains a live connection to your dataset. You can test the connection by modifying data in your data.world dataset; changes you make should update live in PowerBI.

If your PowerBI tables aren't updating as expected, verify that you still have access to the source dataset and that you're using the latest version of Windows.

In this section: