topic Cannot connect to Azure MySQL from Power BI Report Server in Report Server

Cannot connect to Azure MySQL from Power BI Report Server

selimovd — Thu, 09 Jul 2020 07:32:19 GMT

Hello everyone,

I have some issues conneting to my Azure MySQL Server in Power BI Report Server.

On my Power BI Desktop it worked after installing the mysql-connector-net-8.0.20.msi

If I try to configure my data sources on the Power BI Report Server I receive the following error:

Couldn't connect The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly. MySQL: Authentication to host 'XXX.XXX.XXX.XXX' for user 'myUserName' using method 'mysql_native_password' failed with message: SSL connection is required. Please specify SSL options and retry.

Did anyone receive that error? How can I make it work also on the Report Server?

Thank you and best regards

Re: Cannot connect to Azure MySQL from Power BI Report Server

d_gosbell — Mon, 13 Jul 2020 03:33:07 GMT

I can't speak to this error specifically as I don't have any instances of mySql. But in general if you have to install a 3rd party provider on your desktop to get things to work there you would also need to install the same provider on the Report Server

selimovd wrote:

I have some issues conneting to my Azure MySQL Server in Power BI Report Server.

On my Power BI Desktop it worked after installing the mysql-connector-net-8.0.20.msi

Have you also installed this same msi on the Report Server?

Re: Cannot connect to Azure MySQL from Power BI Report Server

pinar1 — Thu, 09 Dec 2021 14:32:23 GMT

Hi ! Has anyone found a solution for this problem?