Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
tmFernandes
Regular Visitor

Connecting Postgresql Azure with Power BI Cloud

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.

2 REPLIES 2
Shravan133
Solution Sage
Solution Sage

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
New Member

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors