Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
selimovd
Super User
Super User

Cannot connect to Azure MySQL from Power BI Report Server

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

2 REPLIES 2
pinar1
Frequent Visitor

Hi ! Has anyone found a solution for this problem? 

d_gosbell
Super User
Super User

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?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.