Forum Discussion

admiraldata's avatar
admiraldata
Frequent Visitor
8 years ago
Solved

Unable to connect to MySQL PaaS

  I've migrated my MySQL database to Azure MySQL PaaS.   When I test the connection on the gateway on the machine, it works:     However, when I try to connect to the same datasource in t...
Gateways
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi admiraldata,

     

    As the issue is gone now, may I close this thread? 

     

    Best Regards,
    Qiuyun 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi admiraldata,

 

Based on my test with the latest on-premise data gateway, as long as the machine hosts on-premise data gateway has MySQL provider installed, we can add azure MySQL data source in Manage Gateways successfully.

 

In your scenario, please check if the machine hosts on-premise data gateway has installed the MySQL provider. If the same machine has Power BI desktop, you can get data from azure MySQL in desktop to test if connection is successful. Also please run the latest gateway version to avoid potential problem. 

 

Note: Do mask sensitive data before uploading.

 

Best Regards,
Qiuyun Yu