Skip to main content

Power BI

New

Azure MySQL Connection

Vote (17) Share
James Lovegrove's profile image

James Lovegrove on 05 Feb 2016 01:30:33

Now that Azure are selling MySQL servers, could you please set it up in the PowerBI service to auto-refresh from it.

Thanks!

Comments (2)
James Lovegrove's profile image Profile Picture

fd13953d 48b3-4d1d-bbfd-5e068f1564cc on 05 Jul 2020 22:56:41

RE: Azure MySQL Connection

At the moment we can use the gateway to refresh but it would be better to connect directly to Azure please?

James Lovegrove's profile image Profile Picture

7ca9d2a7 adb9-41c2-8dd1-dd6bacc35518 on 05 Jul 2020 22:53:16

RE: Azure MySQL Connection

Mysql server is listed as a connection option on latest version (June2017) but doesn't appear to work for us, maybe its due to the SSL requirement for the connection we have on Azure? Or connector API difference? Just freshly installed everything it said we needed. The IP address is allowed as can connect with mysql command prompt and HeidiSQL gui app.