Forum Discussion
Connect to PostgreSQL database with firewall
Hi,
I'd like to use Power BI with PostgreSQL database in my company. I need to whitelist PowerBI addresses in my firewall but I don't know where to find proper IP addresses. Is there any simple solution to find them? As I understand it properly -> the PowerBI cloud service will be asking for data so IP address of my PC is unecessary?
Looking for help!
Hi, Anonymous
As Power BI Service is cloud-based service, its IP address could be different each time within each region. You can download Microsoft Azure Datacenter IP Ranges to monitor the dynamic IP range on time. The generated file contains the IP address ranges used in the Microsoft Azure Datacenters.
Please note that this IP list is updated weekly.
See the links below for more information:
https://docs.microsoft.com/en-us/power-bi/admin/power-bi-allow-list-urls
https://rajanieshkaushikk.com/2019/08/08/power-bi-gateway-proxy-configuration/
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Anonymous , if you know URL, you can run this on command prompt
For your system ip, you need to run
ipconfig
For any url, say google.com
nslookup google.com
Hello Anonymous @amitchandak
Did you find a solution to your problem ? I have exactly the same issue. I developed some reports in my local machine, but my company has network rules to limit access to our databases.
I have installed a gateway in my local machine, but when I publish the report in the power bi service, I cannot refresh the dataset. How do you manage this issue ? Since the IP address can change based on the region etc because it's based on Azure, I don't know how I can manage this issue.
Thank you for your response.
Hi, Anonymous
As Power BI Service is cloud-based service, its IP address could be different each time within each region. You can download Microsoft Azure Datacenter IP Ranges to monitor the dynamic IP range on time. The generated file contains the IP address ranges used in the Microsoft Azure Datacenters.
Please note that this IP list is updated weekly.
See the links below for more information:
https://docs.microsoft.com/en-us/power-bi/admin/power-bi-allow-list-urls
https://rajanieshkaushikk.com/2019/08/08/power-bi-gateway-proxy-configuration/
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
