Quickstart: Import data from Azure Database for PostgreSQL - Flexible Server in Power BI

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

In this Quickstart, you learn how to connect with Azure Database for PostgreSQL flexible server with Power BI Desktop. With Power BI Desktop, you can visually explore your data through a free-form drag-and-drop canvas, a broad range of modern data visualizations, and an easy-to-use report authoring experience. You can import directly from the tables or import from a SELECT query. This article applies to Power BI Desktop only. Currently, Power Query online or Power BI Service is not supported.

Prerequisites

• Install Power BI desktop.

Connect with Power BI desktop from Azure portal

Get the connection information needed to connect to the Azure Database for PostgreSQL flexible server instance. You need the fully qualified server name and sign in credentials.

1. Sign in to the Azure portal.

2. From the left-hand menu in Azure portal, select All resources, and then search for the server you've created (such as mydemoserverpbi).

3. Select the server name.

4. From the server's Overview panel, Select Power BI setting from the left-hand menu.

   

5. Select a database from the dropdown, for example postgres and then select Get started.

6. Download the Power BI desktop file mydemoserverpbi_postgres.pbids.

   

7. Open the file in Power BI desktop.

8. Switch to Database tab to provide the username and password for your database server.

   Note

   Windows authentication is not supported for Azure Database for PostgreSQL flexible server.

   

9. In Navigator, select the data you require, then either load or transform the data.

   

Connect to Azure Database for PostgreSQL flexible server database from Power BI Desktop

You can connect to Azure Database for PostgreSQL flexible server with Power BI desktop directly without the use of Azure portal.

Get the Azure Database for PostgreSQL flexible server connection information

1. Sign in to the Azure portal.
2. From the left-hand menu in Azure portal, select All resources, and then search for the server you've created (such as mydemoserverpbi).
3. Select the server name.
4. From the server's Overview panel, make a note of the Server name and Server admin login name. If you forget your password, you can also reset the password from this panel.
5. Go to Databases page to find the database you want to connect to. Power BI desktop supports adding a connection to a single database and hence providing a database name is required for importing data.

Add Azure Database for PostgreSQL flexible server connection in Power BI desktop

1. Select the PostgreSQL database option in the connector selection.

   

2. In the PostgreSQL database dialog, provide the name of the server and database.

   

3. Select the Database authentication type and input your Azure Database for PostgreSQL flexible server credentials in the User name and Password boxes. Make sure to select the level to apply your credentials to.

   

4. Once you're done, select OK.

5. In Navigator, select the data you require, then either load or transform the data.

   

Connect to Azure Database for PostgreSQL flexible server database from Power Query Online

To make the connection, take the following steps:

1. Select the PostgreSQL database option in the connector selection.

2. In the PostgreSQL database dialog, provide the name of the server and database.

   

   Note

   Data gateway is not needed for Azure Database for PostgreSQL flexible server.

3. Select the Basic authentication kind and input your Azure Database for PostgreSQL flexible server credentials in the Username and Password boxes.

4. If your connection isn't encrypted, clear Use Encrypted Connection.

5. Select Next to connect to the database.

6. In Navigator, select the data you require, then select Transform data to transform the data in Power Query Editor.

Connect using advanced options

Power Query Desktop provides a set of advanced options that you can add to your query if needed.

The following table lists all of the advanced options you can set in Power Query Desktop.

Advanced option	Description
Command timeout in minutes	If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. This option is only available in Power Query Desktop.
SQL statement	For information, go to Import data from a database using native database query.
Include relationship columns	If checked, includes columns that might have relationships to other tables. If this box is cleared, you won't see those columns.
Navigate using full hierarchy	If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data.

Once you've selected the advanced options you require, select OK in Power Query Desktop to connect to your PostgreSQL database.

Share your suggestions and bugs with the Azure Database for PostgreSQL product team.

Related content

• Manage Azure Database for PostgreSQL - Flexible Server.
• Build visuals with Power BI Desktop.
• Quickstart: Use Python to connect and query data from an instance of Azure Database for PostgreSQL flexible server.
• Quickstart: Use Java to connect and query data from an instance of Azure Database for PostgreSQL flexible server.
• Quickstart: Use .NET (C#) to connect and query data from an instance of Azure Database for PostgreSQL flexible server.
• Quickstart: Use Go language to connect and query data from an instance of Azure Database for PostgreSQL flexible server.
• Quickstart: Use PHP to connect and query data from an instance of Azure Database for PostgreSQL flexible server.
• Quickstart: Use Azure CLI to connect and query data from an instance of Azure Database for PostgreSQL flexible server.