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

Azure SQL Firewall and Powerapps

I successfully connected to my Azure SQL with PowerApps with amazing ease.

If I want to connect to my database via other means I have to configure the firewall settings to allow access.

 

I'm interested to know how PowerApps gets around this and is there any way I can control this?

 

I would also like to know

  • if this firewall bypass is cross-tenant?
  • if other applications have this superpower? Office 365?
  • if I can monitor how my database is being accessed?
2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Azure SQL Firewall and Powerapps

Hi @RobSlavin,

 

I think here you mean the SQL Server connection sharing?

Please refer to the article below:

Share app resources

Quoted:

"

Some types of connections, such as SQL Server, are shared automatically, but others require users to create their own connections to the data source or sources in the app.

On powerapps.com, you can determine whether a connection will be shared automatically, and you can update sharing permissions. In the left navigation bar, click or tap Manage, click or tap Connections, and then click or tap a connection. If the Share tab appears, the connection will be shared automatically.

"

For Azure SQL firewall, you might need to configure it with a proper IP range, in order to make the sharing work.

Azure SQL Database server-level and database-level firewall rules

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Azure SQL Firewall and Powerapps

Hi Michael,

 

Thanks for your reply, I do not mean SQL Server connection sharing.

However, your response led me to the "allow access to azure services" option.

 

This appears to be the mechanism which allows PowerApps to access my database even though I have not explicitly set a firewall rule for PowerApps.

 

As the "allow access to azure services" rule allows access for all applications hosted on Azure, including applications from other customers, I would like to create a rule to allow PowerApps only.

 

Thanks,

 

Rob

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (9,836)