Share via

Better enterprise connectivity to SQL Server

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Admins, makers, or analysts, automatically This feature is released. Oct 21, 2019 Mar 2020

Feature details

As enterprises move their workloads to the cloud, they depend more on Azure AD–based authentication to manage access to their Azure SQL Database. Azure AD provides better security because access control is enforced at the data source. You no longer must manage separate user accounts and authentication for SQL Server.

In this release, we've added support for Azure AD authentication for SQL Server from Power Apps and Power Automate. There's no impact on existing users. Enterprises benefit from using an enhanced security model for their data sources, apps, and flows. Makers can now seamlessly connect their apps and flows to Azure SQL Database and rely on Azure AD to secure the underlying database.

When you share apps, each user authenticates directly with the database by using their own identity.

Other improvements in the SQL Server connector include enhanced support for date types (date, datetime, datetime2, and smalldatetime). When you use these data types from Power Apps, they participate and will delegate the processing to SQL Server.

See also

Azure Active Directory authentication in the SQL Server connector (blog)