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
7 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. 

psdhillon1's avatar
psdhillon1
Helper I
5 years ago

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.