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
raymond's avatar
raymond
Post Patron
6 years ago

We are having the same issue. It seems as if you need an VPN Access and something called Bastion which is installed on one EC2 instance. With a tool putty you can have access to your DB. With the VPN (we want to use Open VPN) you might get a connection via powerBi to the DB. 

 

I havent tested it because switching the DB in AWS to private cases so much trouble. We have just let them to public. 

 

If you have any more information about the succcess of your approach, please let me know. It seems to me as if microsoft deliberatly doesnt want to support aws products. 

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>