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
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.
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:
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.
Install the Gateway: If you haven’t already, download and install the on-premises data gateway from the Microsoft Power BI website.
Sign in: During installation, sign in with your Power BI credentials and register the gateway.
Configure Data Source: Once installed, open the gateway application, go to the "Data Sources" section, and add a new data source.
Set Up PostgreSQL Data Source:
Since Power BI Service IPs are dynamic and can change, you have a couple of options:
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.
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.
Publish Your Report: Publish your Power BI Desktop report to the Power BI Service.
Configure Dataset Settings:
Schedule Refresh: Set up a scheduled refresh for your dataset to ensure it gets updated automatically.
Have you found the solution if so please share it. Have you select the Public access in Server?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.