Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Laocsulak
Helper I
Helper I

Best way to schedule refresh Power Bi connected using Mysql connector for AWS RDS

Hello,

 

In my company, I generate Power BI reports for various areas by connecting through the MySQL connector to some views I created using MySQL to connect to an AWS RDS.

 

The issue is that I am updating the dashboards using a gateway on my computer, and even though everything updates correctly, I have to keep my computer permanently on for this to work. What alternatives can I use to avoid having to always leave my computer on?

 

I'm connecting to the databases using the 'import' mode; would switching to 'DirectQuery' instead of 'import' be a solution? Could this cause the dashboards to start running very slowly? Currently, my Power BI Desktop file is 450 megabytes.

 

Thank you in advance!

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @Laocsulak ,

 

Do you have the option to spin up a VM and run the gateway on there? Both DirectQuery and Import mode need a gateway to connect to your MySQL DB on AWS.

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

4 REPLIES 4
Laocsulak
Helper I
Helper I

I created the virtual machine with an EC2 instance of Windows and installed the gateway there and it's working perfectly. Thank you!

Laocsulak
Helper I
Helper I

Thank you for the reply. So, is the best option to create a virtual machine on AWS? Should I create an EC2 instance for that? Or is there a better option without needing to do that?

Hi @Laocsulak ,

 

I have never done it myself, but the way you suggested, I would go for.

 

AWS seems to propose EC2 as well.

Connecting the Microsoft Power BI service to AWS data sources - Using Microsoft Power BI with the AW...

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

tackytechtom
Super User
Super User

Hi @Laocsulak ,

 

Do you have the option to spin up a VM and run the gateway on there? Both DirectQuery and Import mode need a gateway to connect to your MySQL DB on AWS.

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors