Unable to connect to MySQL PaaS

I have uploaded the last 7 days of logs. The ReportID for the logs is 3e358717-7be8-4f00-b65a-44fdeea9ed0b

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

Hi Qiuyun,

If the machine did not have the MySQL driver, then I wouldn't be able to connect in the diagnostics screen right?

As you requested, on the same machine, I tried PBI and I am able to connect:

The gateway is also up-to-date:

All of that works, but the gateway config on the PowerBI service still gives me the error. What's next - how do we identify how to fix this?

Hi admiraldata,

Based on my test, once the machine hosts the data gateway doesn't install the MySQL provider, the same error will occur. 

In your scenario, it seems you install the separate self-hosted integration runtime on the same machine has gateway run. According to this:

• If you already have a gateway installed on your computer serving a Power BI scenario, install a separate self-hosted integration runtime for Azure Data Factory on another machine.

Please uninstall the self-hosted integration runtime then test again. 

Best Regards,
Qiuyun Yu

Hi Qiuyun,

You're right. As soon as I stopped the Azure self hosted integration runtime, the gateway started to work fine.

Thanks for your help!