Answered

PowerApps - Data Integration via PowerApps, Firewall Question

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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!

Categories:

Governance & administering

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

v-monli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

It seems that you have posted a duplicated thread here:

https://powerusers.microsoft.com/t5/General-Discussion/IP-Address-missing-from-limits-and-config-list/td-p/294825

Please see replies in the above link.

Regards,

Mona

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No