cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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
Community Support
Community Support

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

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
Community Support
Community Support

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

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!

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
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Users online (12,157)