Announcements
Hello,
Is it possible to use Interactive authentication for Azure SQL on Power Automate? I got it working in python with an ODBC but I don't see that as an option. I tried with Integrated security but I can't specify the server there?
PA Cloud or PA Desktop?
PA Cloud
For the overwhelming majority of scenarios you need to assume that PA Cloud has no user interface and therefore cannot be interactive. There are some punchouts like approval workflows and Teams adaptive cards, but I can't see them being useful in your scenario.
Integrated Security/SSPI assumes the presence of a NT user account - which is not a thing in PA Cloud.
So how are we supposed to connect with an azure sql database with PA Cloud if username/password (basic authentication) is not an option?
AAD - Azure Active Directory authentication in the SQL Server connector | Power Automate Blog (microsoft.com)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Mohsin Ali 426
11manish 345 Super User 2026 Season 2
M Bilal Khan 308
