[Need Help] Import Data from Azure Database for MySQL

[AdeleVance]

myHi there, 

When I tried to import data from azure database for MySQL, I've gotten the connection error like below. 

"MySQL: Authentication to host '*****.mysql.database.azure.com' for user '*****' using method 'mysql_native_password' failed with message: The connection string may not be right. Please visit portal for references."

I already set firewall rules for my client IP and installed all of required connector for MySQL but connection has not been completed yet. 

Do you have any idea for this? 

Thank you

[v-danhe-msft · Accepted solution]

Hi @AdeleVance ,

Based on my research, could you have refered to below link about how to configure Azure Database for MySQL server:

https://docs.microsoft.com/en-us/azure/mysql/quickstart-create-mysql-server-database-using-azure-por...

And below link has tested how to connect in Power BI:

https://community.powerbi.com/t5/Integrations-with-Files-and/Connection-string-for-Azure-My-SQL-Data...

Regards,

Daniel He