Based on my understanding of the question its just an issue caused by changing of IP when switching to VPN in home network. For this use case the customer can possibly consider the below workarounds. Also
Instead of installing Tableau desktop on user desktop it can be installed on a Virtual Machine or a EC2 instance and they use that instance for connection to DB.
Rather than opening a single user IP you can allow the user IP and also VPN IP range for the company. This is little less secure as it opens the database to any user within the organization.
Connecting Users to AWS Athena and AWS Lake Formation via Tableau Desktop using the Simba Athena JDBC Driver and Okta as Identity Providerasked 5 months ago
Private Redshift cluster connectivity from tableau webasked 8 months ago
Not able to connect with Tableau Desktop to Amazon Athena. Error: AA76601Fasked a year ago
Tableau version upgradeasked 3 months ago
Unable to RDP EC2 instance from local desktopasked a month ago
Installing Tableau on Server and Serverless EnvironmentAccepted Answerasked a year ago
Tableau Desktop to RedshiftAccepted Answerasked 2 years ago
Amazon Athena JDBC42 driver issue while running queries from Tableauasked 3 months ago
Remote Desktop can’t connect to the remote computerasked a year ago
Athena to Tableau Error Code: AA76601Fasked 3 months ago