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.
Note: The following procedure shows how to connect in Power BI Desktop (version 2.93.981.0 ). For any other versions, please see the respective documentation on how to establish a PostgreSQL connection.
You have datasets (your own or shared with you) in the Datasets pane.
You installed a Power BI application that has an option to connect to PostgreSQL.
If you are prompted to install Npgsql, ensure you install it into the GAC.
In Power BI, on the Home ribbon, select Get Data.
In the Get Data dialog, click Database, and then select PostgreSQL database.
In the PostgreSQL database dialog:
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.
- Enter the name of the PostgreSQL database, which is datasets by default.
- Under Advanced options, deselect Include relationship columns.
- Click OK.
Enter the user credentials, and click Connect.
In the message about encryption support, click OK.
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.
In the Fields pane on the right, view the added datasets.
Now, you can visualize your data as needed.