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

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.