Use datasets in Power BI

You can use and analyze your datasets in Power BI. To do that, you need to connect from Power BI to the datasets through a PostgreSQL connection.

Prerequisites

• You have datasets (your own or shared with you) in the Datasets pane.

• You installed a Power BI application.

Procedure

1. In Power BI, on the Home ribbon, select Get Data.

   

2. In the Get Data dialog, click Database, and then select PostgreSQL database.

   

3. Click Connect.

4. In the PostgreSQL database dialog:

   1. Enter the name of the server (including the port number), where:

      • The server name is the name or IP address that was configured for the application.

      • For the TCP server port, enter 5432.

      Example: 10.12.13.201:5432

   2. Enter the name of the PostgreSQL database, which is datasets by default.
   3. Under Advanced options, deselect Include relationship columns.
   4. Click OK.

   

5. Enter the user credentials, and click Connect.

   

6. In the message about encryption support, click OK.

   

7. In the Navigator dialog, select the datasets (shown as separate tables) that you want to upload, and then click Load.

   Note: The dataset name includes the dataset ID number at the end to ensure that all dataset names are unique.

   

8. In the Fields pane on the right, view the added datasets.

   Now, you can visualize your data as needed.