cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
corbusier 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: https://www.microsoft.com/en-us/download/details.aspx?id=41653

 

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?

2 REPLIES 2
Community Support
Community Support

Re: Programmatically add Power BI Service IP addresses to whitelist?

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?

 

Regards,

Jimmy Tao

corbusier Advocate III
Advocate III

Re: Programmatically add Power BI Service IP addresses to whitelist?

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

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.