Showing results for 
Search instead for 
Did you mean: 
Advocate III
Advocate III

Programmatically add Power BI Service IP addresses to whitelist?

I understand that Power BI Service IP Addresses are available at the following URL:


However, these are updated every week. Is there a programmatic way to get these IP addresses into another service, such as an AWS Security Group?


Downloading an XML file every time to update the IP addresses by hand has got to be not the ideal solution Microsoft is envisioning, right?

Community Support
Community Support

Hi corbusier,


Are you trying to scrapying the power bi service ip in an assigned interval? If you are, not sure if microsoft will take action to block your ip, you can write some spider programs to do this. However, why do you want to achieve power bi service ip? What's your requirement?



Jimmy Tao

In order for the Redshift server to let the Power BI service through the firewall, I need to add the IP addresses from the Power BI service to the whitelist on AWS. Microsoft says that these IP addresses can change from week to week. I'd like to keep the list updated, at least for my Power BI region's IP addresses. Is there a way to do this automatically? 

This problem doesn't occur when using Azure DWH or SQL DB, since both are Microsoft services. However with other services where the firewall access is limited, its a pain.

Helpful resources



We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors