Skip to content

Power Apps

Can Power Apps connect to SQL Server?

By Suresh Girinathuni

Quick answer

Yes. Power Apps connects to SQL Server — on-premises via the on-premises data gateway or Azure SQL directly — for galleries, forms, and Patch against tables and views, plus stored-procedure execution. It suits apps modernizing an existing relational backend without migrating data. Because the SQL connector carries premium-licensing implications and gateway ownership burdens, verify current licensing and assign a gateway owner before committing an enterprise app to it.

Key takeaways

  • SQL connector covers tables, views, and stored procedures.
  • On-prem needs a gateway with an assigned owner.
  • Verify premium licensing; keep heavy logic in the database.

Detailed Explanation

Yes. Power Apps connects to SQL Server — on-premises via the on-premises data gateway or Azure SQL directly — for galleries, forms, and Patch against tables and views, plus stored-procedure execution. It suits apps modernizing an existing relational backend without migrating data. Because the SQL connector carries premium-licensing implications and gateway ownership burdens, verify current licensing and assign a gateway owner before committing an enterprise app to it.

How it works

Install and register the gateway on an always-on machine for on-prem sources, create the connection under a service identity with least-privilege database rights, and bind controls to tables. Delegation to SQL is stronger than to SharePoint but still verify large-query behavior.

Limitations and considerations

Gateway downtime takes on-prem apps offline; credentials and database permissions need lifecycle ownership. Heavy transactional logic belongs in procedures or APIs, not gallery formulas.

For broader context, see the Power Apps Code Hub — it collects the guides around this topic.

When to use it

Choose SQL when the system of record already lives in SQL Server and must stay there; choose Dataverse when building new governed business data.

Practical example

An order-lookup app reads the existing ERP SQL views through a gateway while new approval metadata lives in Dataverse — no data migration, clear ownership split.

Related Questions

Can Power Apps connect to SharePoint?Yes — SharePoint lists and libraries are first-class Power Apps data sources via the SharePoint connector, ideal for departmental apps. Plan for delegation limits on large lists and graduate to Dataverse when relational needs grow.What is Power Apps?Power Apps is Microsoft’s low-code app platform with three paths: canvas apps for pixel-perfect task screens, model-driven apps generated from Dataverse data models, and Power Apps Code for pro-code React development.Is Dataverse a database?Partly: Dataverse stores data like a database, but it is a business application platform — tables ship with security roles, business logic, APIs, auditing, and Power Platform ALM attached.When should I use Dataverse instead of SharePoint for Power Apps?Choose Dataverse when the app needs table relationships, row-level security, auditing, solution ALM, or Dynamics 365 integration. Stay on SharePoint for simple team tools with flat data and list-level permissions.

Related nxtM365 Guides

Power AppsConnect Power Apps Code Apps to Azure SQLLearn how to connect Power Apps Code apps to Azure SQL Database with PAC CLI, secure authentication, queries, stored procedures, and scalable enterprise data patterns.DataverseDataverse with Power Apps: Canvas and Model-Driven Patterns | Day 19Build Power Apps on Dataverse with the right canvas or model-driven pattern so forms, views, relationships, and security work together.

Sources