Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, 

 

I confirm that RDS in public subnet, we can able to connet this source from differnet tools with correct credentials. How can we tell to Power BI server to use SSL while connectiong to RDS MySql. 

 

Thank you,

Sri

raymond's avatar
raymond
Post Patron
5 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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>