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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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!

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

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://community.powerbi.com/t5/Service/API-requires-Power-Bi-Ip-address-range-to-Whitelist/td-p/252081

https://community.powerbi.com/t5/Service/How-to-know-IPs-related-to-Powerbi-online-for-Opening-Firewall/td-p/326417

https://community.powerbi.com/t5/Service/What-is-the-right-method-to-allow-Power-BI-service-IPs-through/m-p/977691

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.

View solution in original post

4 REPLIES 4
v-angzheng-msft
Community Support
Community Support

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://community.powerbi.com/t5/Service/API-requires-Power-Bi-Ip-address-range-to-Whitelist/td-p/252081

https://community.powerbi.com/t5/Service/How-to-know-IPs-related-to-Powerbi-online-for-Opening-Firewall/td-p/326417

https://community.powerbi.com/t5/Service/What-is-the-right-method-to-allow-Power-BI-service-IPs-through/m-p/977691

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.

amitchandak
Super User
Super User

@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

Anonymous
Not applicable

HI, thanks for response, but as I understand I do not need my IP, I need PowerBI server IP address cause this server will ask our database for data. The competitors publish this IP on their web sites I cannot find it anywhere in PBI...

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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