I have created an Azure SQL DB, with the public access off, and private endpoint created for private connectivity.
I am trying to access the Azure SQL DB via Power Apps and Power Automate, but each time, it fails to connect and asks me to whitelist the 'public' ip in the Azure SQL DB firewall. I am not fond of this approach of whitelisting public IPs.
Is there any other way to connect Azure SQL DB from Power Apps privately?
@MIS @Microsoft2 @Reza @ShaneYoung @PS