I am a citizen developer who has created some Power Apps using Sharepoint Lists as my data source. I would like to work with Azure SQL for some more complex databases. Our company is very strict, rightly so, about data security, and they are saying that they insist that the sql instance be on a vnet with private endpoints. I'm just a citizen developer who hasn't ever had to worry about the security in an on-prem instance as the dba's worry about it. But Azure and the Power Platform is new to them and they are being extremely cautious. Surely other companies have battled with their own IT Security and found a solution that works. In my research I found this...
- Power Apps can't connect to SQL Database using VNet Service Endpoints. For more information, read allowing access through VNet Service Endpoints. https://docs.microsoft.com/en-us/azure/azure-sql/database/vnet-service-endpoint-rule-overview?view=azuresqlhttps://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-azure-sql-database which links to
My goal is to make this data source available to the power platform and 3rd party solutions via API. The bullet above seems to state it's not possible. But then the next link describes what can be done. I'm totally confused and can't seem to get a straight answer that is understandable to me. If not a vnet with private endpoints then what can I propose to our IT security folks as the next best alternative.