Forum Discussion
Connect Powerbi with AWS RDS with no public accessibility
We're trying to integrate Power BI in our company. However, we're failing to connect with AWS services. Currently, we use a MySql database hosted on AWS RDS, the problem is that, we don't use public...
If any one of you finds a way please let me know. So far we werent able to do it. However we use the public subnet and whitelistet IP Ranges...that worked for us a security measure even though it is not that bullet proof.
Only way I have found is to open an ssh tunnel to a box in the VPC and bind your local port the that of the RDS instance itself, kinda like:
ssh -L 3306:<rds.amazonaws.com-custom-url>:3306 <ip-of-vpc-box>