Forum Discussion
Connect Powerbi with AWS RDS with no public accessibility
Hi stsau ,
Just started my journey into AWS side; I am also came into same situation.
Interested to know how to connect to RDS (MySQL) on private subnet with Power BI for reporting.
Thank you,
Sri
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.
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
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>
Hey raymond I have got dual securtiy layer the way you mentioned. Bastion server with vpn access. I am trying out with putty, with which i am able to connect & access the database, but my powerbi still not able to see the database, what am i missing ? any clue would be appreciated.
