Use shareable Service Principal Name with Power Apps
We are excited to announce an enhancement in how Power Apps connects to SQL Server. Service Principal Name (SPN) based connections are now shareable! This enhancement marks a key step forward in simplifying and securing access to your enterprise applications.
Previously, a SPN based connection was not shareable, which meant that if an app was created with a connection using SPN, every user working with that app would need the specific SPN credentials. While usable for services such as Power Automate where the service runs in the background, this approach does not work for Power Apps. This change streamlines the user experience and is secure.
SPN is protected by secure implicit connections, ensuring that your data remains safe and secure. This feature is now available through regions up to North America, with government regions coming online in the coming weeks. SPN connections should generally be authored by tenant admins and carefully shared with development organizations.
This update makes SPN usable for Power Apps over SQL Server. Stay tuned for more updates as we continue to enhance our platform to better serve your needs.
See https://learn.microsoft.com/en-us/connectors/sql/#service-principal-authentication for details on how to set it up for your application.
