Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi ! Has anyone found a solution for this problem?
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
13 | |
11 | |
7 | |
3 | |
3 |