cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kimkantola
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
v-monli-msft
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
v-monli-msft
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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Users online (93,062)