
Announcements
I have an interesting issue... I am trying to connect to a Microsoft SQL Server that is part of our Azure Serverless SQL Pool in Power Automate. The Server uses Microsoft EntraID Authentication and it is behind our firewall (so technically on-premises). I have a Power Automate Gateway stood up to allow connections into our internal environment.
When I try to set up a connection to the SQL Server, if I choose EntraID, there is no option to select a Gateway. It seems the Gateway option is only available if I connect via SQL Server or Windows Server authentication.
I noticed a similar issue when trying to connect to Blob Storage. Our Blob Storage is also behind out firewall, but there is no option to select a Gateway if I use EntraID authentication.