Toronto Power BI, Power Apps, Power Automate User Group

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.
 View Only
  • 1.  Issue connecting to MySQL

    Posted Mar 27, 2020 09:05 PM
    Hello !

    Am facing below issue while configuring an action to connect to MySql database from PowerAutomate. Need to do some gateway configuration?

    Failed to create connection for connection id '/providers/Microsoft.PowerApps/apis/shared_mysql/connections/shared-mysql-791E4D15-A7D5-4EE4-9865-F17BA3CFD414'. There's a problem creating this connection. Make sure the gateway is online and reinstall it if the problem continues.


    Regards
    Rohan

    ------------------------------
    Rohan Shetty
    ------------------------------


  • 2.  RE: Issue connecting to MySQL

    Bronze Contributor
    Posted Apr 07, 2020 11:15 AM
    Edited by Kaushal Kodagoda Apr 07, 2020 11:17 AM
    Hi Rohan,

    You need on premises data gateway to be installed in your machine locally to access the SQL DB via Power Automate.

    This acts as the bridge between PowerPlatform and your local SQL DB. See below link for further details.

    https://docs.microsoft.com/en-us/power-platform/admin/onpremises-data-gateway-management

    Thanks

    ------------------------------
    Kaushal Kodagoda
    Technical Consultant - D365 CE
    http://immersivecoder.wordpress.com
    ------------------------------