Scheduled refresh for AWS-hosted database without connecting VPN every time
Hi everyone, I have a dashboard published in Power BI Service, connected to our company database hosted on Amazon AWS (RDS). The database is only reachable when I’m connected to the company VPN, so I have to connect the VPN every time I refresh the data. I have already installed an on-premises data gateway. Goal: Set up scheduled refresh in Power BI Service so the dataset refreshes automatically without anyone connecting to the VPN manually.