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
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

Here is a video you could refer to

AWS - Power BI to RDS MySQL Connection

 

What do you mean by  "don't use public accessibility"  and  "AWS RedShift is not an option for us"?

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank v-juanli-msft for replying,

    I tried this video before and it didn't work.

    If you pay atention at 0:35 in the video you'll notice that Public Accessible is "Yes", which is not our case.

    Also, AWS Redshift is quite expensive for us.

     

    Thank you again, any tips about PowerBI is very welcome. I'm trying for a while but not getting anywhere with it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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  

      • 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, 

     

    Just to confirm - it's not possible, without the gateway, to connect to a database with SSL?  Maintaining/patching/making highyly available a gateway is our only option?

     

    Are there any options at all for secure access?  SQLServer?  Postgres?  MySQL?  Redshift?  Perhaps something running specifically in Azure rather than on-premise or another cloud?

     

    Thank you