Connect to AWS RDS via VPN

Hello everyone

I have an AWS RDS (Aurora Postgres) that is inside a private network, can only be accessed through a VPN.

How can I allow PowerBI to view the database in both Desktop & Service? I have the VPN running and the Azure IP address whitelisted, but still getting "host not found" errors.

Any help is highly appreciated, you would love to continue using PowerBI (safely).

Thank you!