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!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.


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