With private IP on VM it's not possible to connect from Power Apps, both are on Microsoft owned networks but separate networks definitely.

Only way around to access SQL DB in Azure VM from Power Apps is to install and configure On-premises gateway on the machine. So, the VM on Azure is on-premise for Power Apps.