cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kimkantola
Level: Powered On

PowerApps - Data Integration via PowerApps, Firewall Question

Hi All,

 

I have created a Data Integration (using the PowerApps Admin Center) from my Azure SQL database to my Common Data Service.

 

Untitled 232.jpeg

 

When the integration runs, It appears that the connection is coming from PowerApps to my SQL Database on port 13.64.188.143.

 

This is not one of the IP addresses that shows up on the powerapps whitelist of Addresses.  Does anyone know of another whitelist that this IP address might be found on?

I want to configure my firewall in Azure to only allow the PowerApps URL's to access port 1433.

 

So far I have only been able to find two sets of IP addresses 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/limits-and-config#ip-addresses

and

https://docs.microsoft.com/en-us/flow/limits-and-config

 

The IP address "13.64.188.143"  does not appear in either of these lists.


Any help appreciated!

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: PowerApps - Data Integration via PowerApps, Firewall Question

Hi @kimkantola ,

 

It seems that you have posted a duplicated thread here:

https://powerusers.microsoft.com/t5/General-Discussion/IP-Address-missing-from-limits-and-config-lis...

Please see replies in the above link.

 

Regards,

Mona

Community Support Team _ Mona Li
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

kimkantola
Level: Powered On

Re: PowerApps - Data Integration via PowerApps, Firewall Question

My colleague found another source of IP addresses that included the mystery IP we were looking for.

 

We also found that these files are updated weekly, so they need to be monitored so that firewall settings can be kept up to date.

 

Here is where the file of IP addresses can be downloaded :  Azure DataCenter IP List

 

The list is updated weekly so must be monitored in order to keep firewall settings up to date.

View solution in original post

3 REPLIES 3
Highlighted
Community Support Team
Community Support Team

Re: PowerApps - Data Integration via PowerApps, Firewall Question

Hi @kimkantola ,

 

It seems that you have posted a duplicated thread here:

https://powerusers.microsoft.com/t5/General-Discussion/IP-Address-missing-from-limits-and-config-lis...

Please see replies in the above link.

 

Regards,

Mona

Community Support Team _ Mona Li
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

kimkantola
Level: Powered On

Re: PowerApps - Data Integration via PowerApps, Firewall Question

Thank you Mona!

That second post I thought I was posting to support.  Thank you for your reply in both places.  When I realized that my second post did not go to a support page as I intended, I could not find a way to delete it, are posts not able to be deleted here?  I am new to the forum so thank you for your help!

kimkantola
Level: Powered On

Re: PowerApps - Data Integration via PowerApps, Firewall Question

My colleague found another source of IP addresses that included the mystery IP we were looking for.

 

We also found that these files are updated weekly, so they need to be monitored so that firewall settings can be kept up to date.

 

Here is where the file of IP addresses can be downloaded :  Azure DataCenter IP List

 

The list is updated weekly so must be monitored in order to keep firewall settings up to date.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Users Online
Currently online: 330 members 5,653 guests
Please welcome our newest community members: