PowerBI Desktop cannot connect to database table on localhost by database credentials

[dejudicibus]

I created a database on localhost which I can access with a read-only guest user account (privileges: SELECT only).

If I access it from the CLI with the mysql command, there are no problems, so the connection works and the credentials are valid.
If I try to access it from PowerBI Desktop, even making sure that I use those credentials in the Global Permissions and not the Windows ones, it responds

We couldn't authenticate with the credentials provided. Please try again.

Please, note that I installed the additional component mysql-connector-net-8.3.0.msi

Any idea why?

[Anonymous]

Hi @dejudicibus ,

Please try below steps:
1. Verify Connector Installation: Ensure that the MySQL Connector/NET is correctly installed on your system. You can verify the installation by opening a PowerShell window and running the following command: 

[System.Data.Common.DbProviderFactories]::GetFactoryClasses()|ogv

This command should list the MySQL Data Provider if the connector is properly installed.

2. Review Connection Details: Double-check the connection details you are entering in PowerBI Desktop. Ensure that the server name is correctly specified as localhost, the database name is accurate, and the credentials (username and password) are correctly entered without any typographical errors.

3. Check PowerBI Desktop Version: Ensure that you are using the latest version of PowerBI Desktop. Power BI Desktop is updated monthly, and using the most recent version can resolve compatibility and connection issues.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dejudicibus]

1. Done: it's ok

2. Done: they are ok

3. Done: Version: 2.128.1177.0 64-bit (April 2024) - same result