Access Evolved
FAQ · Power Platform and data

Can Power Apps connect to SQL Server?

Yes. Power Apps can connect to SQL Server and Azure SQL, subject to connector, gateway, licensing, security, and delegation considerations.

Short answer

Yes. Power Apps can connect to SQL Server and Azure SQL, subject to connector, gateway, licensing, security, and delegation considerations.

What this means in practice

The data source should expose clear primary keys, appropriate views, and operations that the application can perform safely. On-premises SQL Server normally requires a configured data gateway.

✓Use least-privilege database access.
✓Design delegable filters so large datasets are processed by SQL Server.
✓Use views or stored procedures where they simplify secure server-side logic.
✓Plan gateway ownership, redundancy, credentials, and monitoring.
✓Confirm premium licensing for every required user.

The practical next step

A technically successful connection is not the same as a well-performing app. Data design and formula choices determine whether Power Apps retrieves small targeted result sets or struggles with client-side limits.

Related guidance

Explore the relevant service →Read related guidance →Discuss your system →

This answer provides general guidance. The right recommendation depends on your application, data, users, licensing, and business requirements.