Connecting Postgresql Azure with Power BI Cloud

[tmFernandes]

My question may not be complex, but I can't find solutions on the web. I have a postgresql database hosted on azure. Today, to access this bank, it is necessary to configure the specific IP range.

I developed a pbix connecting to these databases, and now I need to configure the connection to this database (through a gateway) to perform the automatic update.
How can I do this? I saw that microsoft's IP ranges are dynamic, so I can't set a range for release. 

In this moment I'm licensing Power BI Pro.

[Shravan133]

To enable automatic updates for your Power BI reports that connect to a PostgreSQL database hosted on Azure, and given that the IP ranges for Power BI services are dynamic, follow these steps:

1. Configure Your On-Premises Data Gateway

You need an on-premises data gateway to bridge your Power BI Service and the PostgreSQL database. Ensure you have installed and configured the gateway on a machine that has access to the PostgreSQL database.

1. Install the Gateway: If you haven’t already, download and install the on-premises data gateway from the Microsoft Power BI website.

2. Sign in: During installation, sign in with your Power BI credentials and register the gateway.

3. Configure Data Source: Once installed, open the gateway application, go to the "Data Sources" section, and add a new data source.

4. Set Up PostgreSQL Data Source:

   • Data Source Type: Choose PostgreSQL.
   • Connection Details: Enter the connection details for your PostgreSQL database (server, database, authentication method).
   • Credentials: Provide the credentials necessary to access the database.

2. Allow Power BI Service IPs in Your PostgreSQL Database

Since Power BI Service IPs are dynamic and can change, you have a couple of options:

1. Allow All Power BI Service IP Ranges: Check the official Microsoft documentation for the list of IP ranges for Power BI service and update your PostgreSQL firewall settings accordingly. Be cautious as this approach opens up your database to all these IP ranges, which might have security implications.

2. Use a Virtual Network (VNet) and Private Link: If you're using Azure PostgreSQL, you can set up a Virtual Network Service Endpoint or Private Link, which provides a more secure connection between your on-premises data gateway and Azure services.

   • Virtual Network Service Endpoint: Configure your Azure PostgreSQL instance to accept connections from the VNet where your gateway resides. This setup ensures that your gateway machine can access the database securely.

   • Private Link: Configure Azure Private Link to securely connect your database to the Power BI Service.

3. Connect Power BI to Your Data Gateway

1. Publish Your Report: Publish your Power BI Desktop report to the Power BI Service.

2. Configure Dataset Settings:

   • Go to the Power BI Service and navigate to your workspace where you published the report.
   • Under Datasets, click on Settings for your dataset.
   • In the Data source credentials section, configure the credentials to use the gateway you set up.

3. Schedule Refresh: Set up a scheduled refresh for your dataset to ensure it gets updated automatically.

Summary

1. Install and configure the on-premises data gateway.
2. Allow Power BI service IPs or set up a secure connection using Azure VNet or Private Link.
3. Configure the dataset in Power BI Service to use the gateway and set up a scheduled refresh.

[Aussupport]

Have you found the solution if so please share it. Have you select the Public access in Server?