cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jagan_MFilterIT
Frequent Visitor

Connecting to MYSQL DB on AWS Which can only be accessed through another server on AWS

Hi, 

 

I am trying to connect to a MySQL DB on AWS EC2 Server. But the problem is due to security restrictions it can only be accessed through another server on AWS. So I have to build a connection like below PowerBI - > AWS EC2 Dev Server -> AWS MySQL DB. 

 

Is it possible to do it? If so can you please help with any references? 

 

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User IV
Super User IV

@Jagan_MFilterIT , You need allow power bi access outside AWS(especially service). You can have a remote machine with a power bi desktop and do the development work in power bi.

Later for Power bi data gateway you have to open port outside cloud so that you can view data on power bi service.

 

You can use a single machine for data gateway and power bi desktop. This machine should able to communicate inside and outside AWS



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

v-yingjl
Community Support
Community Support

Hi @Jagan_MFilterIT ,

About connecting AWS datasource like mysql, you can refer this video which introduces it:

AWS - Power BI to RDS MySQL Connection 

 

In addition, you can try to use OData connector in power bi desktop to try to connect, refer this article:

Import AWS Management Data into the Power BI 

 

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

View solution in original post

2 REPLIES 2
v-yingjl
Community Support
Community Support

Hi @Jagan_MFilterIT ,

About connecting AWS datasource like mysql, you can refer this video which introduces it:

AWS - Power BI to RDS MySQL Connection 

 

In addition, you can try to use OData connector in power bi desktop to try to connect, refer this article:

Import AWS Management Data into the Power BI 

 

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

View solution in original post

amitchandak
Super User IV
Super User IV

@Jagan_MFilterIT , You need allow power bi access outside AWS(especially service). You can have a remote machine with a power bi desktop and do the development work in power bi.

Later for Power bi data gateway you have to open port outside cloud so that you can view data on power bi service.

 

You can use a single machine for data gateway and power bi desktop. This machine should able to communicate inside and outside AWS



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors