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


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

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!.

Top Solution Authors