Connect PowerBI Service to Azure PostgreSQL for Flexible Server via Vnet data gateway

Dinesh Prajapati 126 Reputation points
2023-05-10T11:35:33.51+00:00

Hi team,

Can I connect PowerBI Service to Azure PostgreSQL for Flexible Server via Vnet data gateway.

If yes then can you please tell me the steps

Azure Database for PostgreSQL

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sedat SALMAN 13,265 Reputation points
    2023-05-13T14:42:55.3466667+00:00

    you can connect Power BI Service to an Azure PostgreSQL for Flexible Server via a VNet Data Gateway.

    You can review the following links

    https://azure.microsoft.com/en-us/updates/power-bi-now-supports-direct-query-for-azure-database-for-postgresql/

    https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/how-to-manage-virtual-network-portal

    https://video2.skills-academy.com/en-us/azure/analysis-services/analysis-services-gateway-install?tabs=azure-portal

    Summary as follows

    Set up a VNet and VNet Data Gateway:

    • Create a virtual network (VNet) in Azure that will be used to host your Azure PostgreSQL for Flexible Server and the VNet Data Gateway.
    • Set up a VNet Data Gateway in the virtual network. This will act as a bridge between your Azure PostgreSQL server and the Power BI Service.

    Configure the VNet integration for Azure PostgreSQL for Flexible Server:

    • In the Azure portal, navigate to your Azure PostgreSQL for Flexible Server.
    • Under the "Settings" section, click on "Networking".
    • Enable the "VNet service endpoint" option and select your virtual network and subnet.
    • Save the changes.

    Install and configure the VNet Data Gateway:

    • Install the VNet Data Gateway on a machine within your virtual network. Follow the official documentation for detailed installation steps.
    • Configure the gateway with the appropriate settings, including the virtual network information.

    Connect Power BI Service to Azure PostgreSQL:

    • In Power BI Service, go to the workspace or report where you want to connect to Azure PostgreSQL.
    • Click on "Get Data" and search for "Azure Database for PostgreSQL".
    • Select the "Azure Database for PostgreSQL" connector and click on "Connect".
    • Enter the server name and database credentials for your Azure PostgreSQL for Flexible Server.
    • Choose the "Connect via On-premises Gateway" option and select the VNet Data Gateway you configured.
    • Click on "Connect" to establish the connection.
    0 comments
  2. Oury Ba-MSFT 17,631 Reputation points Microsoft Employee
    2023-05-15T21:34:40.2033333+00:00

    Dinesh Prajapati Thank you for posting your question on Microsoft Q&A forum.

    My understanding is that you are trying to connect Power BI service to a PostgreSQL flexible server using vnet Data Gateway.

    There is a new PostgreSQL connector for the virtual network data gateway you can use to connect to Power BI.

    To use this connector with vnet data gateways, you have a few options. With Power BI Desktop, you can connect and then publish. Then, log in online and create a dataset from your published file. You can enable this dataset with vnet data gateways. Refer to the below blog for step-by-step instructions on how to do this.

    The vnet data gateway is only compatible with PBI datasets, paginated reports (and there are future plans to connect to dataflows)

    PostgreSQL connector for the virtual network data gateway

    Please do not forget to mark as accept answer if the reply was helpful.

    Regards,

    Oury