Skip to main content

Documentation

Connect to PowerBI using Postgres Proxy

The following steps will walk you though connecting to PowerBI using Postgres Proxy:

  1. Open up PowerBI and navigate to Get Data

    postgres_proxy_PBI_1.png
  2. Select PostgreSQL database:

    postgres_proxy_PBI_2.png
  3. On the next screen enter:

    1. postgres.data.world:5432 for the server

    2. Your agentID or organization/dataset name for the database

    Select DirectQuery for the data connectivity mode.

    postgres_proxy_PBI_3.png
  4. Select OK and enter your Read/Write API token for the password.

    postgres_proxy_PBI_4.png
  5. You can find your API token on the Advanced tab of your profile. See this article for detailed instructions.

    postgres_proxy_PBI_5.png