Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Problem connecting to MySQL

(1) ShareShare
ReportReport
Posted on by 11

Hi Everyone.

 

I am currently trying to create a scheduled cloud flow that gets data from a MySQL database and writes it to an excel spreadsheet.

 

I have a MySQL DB hosted on AWS and an On-Premise Gateway set up on an EC2 instance.

 

In Power Automate, I go to Connections > New connection > MySQL and insert all the details about the connection. When I press 'Create', it greys out the button and a message says 'Adding connection...' at the top. It remains this way for about 10 seconds and then the 'Create' button becomes clickable again, without any error message.

 

I know that my gateway works fine because I can access it on the Power BI service and my data refreshes as it should. The MySQL credentials that I am using work well everywhere else. I cannot figure out where the problem is coming from.

If you have any idea what is going on, please share.

 

Thank you

  • LeDataGuy Profile Picture
    LeDataGuy 11 on at
    Re: Problem connecting to MySQL

    I am using the On-premise gateway, what you are seeing in the screenshot is just the name of the Gateway because it was initially built for Power BI purposes only.

     

    It turns out that I wrongly capitalized one letter of the Database name. And the gateway logs clearly show that as the error. Thank you @FLMike for pointing me in the right direction.

     

    Also, fixed the Italics 🙂

  • Verified answer
    FLMike Profile Picture
    FLMike 31,580 on at
    Re: Problem connecting to MySQL

    Hi @LeDataGuy 

     

    Pretty please don't write everything in italics 😞 ouch my eyeballs.

     

    Also I notice that you are using the Power Bi data gateway not the On-Premise data gateway. They separated them out, so you should look for that versus the power BI data gateway

     

    1. have you verified that the SQL port you are using is open on the Firewall on the AWS side? 

     

    2. Can you look at the Logs of the Gateway and verify that the attempt was made and potentially why it failed?

     

    3. Can you try it in an incognito, cleared cache, browser instance please.

     


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics