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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dejudicibus
Frequent Visitor

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

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?

2 REPLIES 2
v-binbinyu-msft
Community Support
Community Support

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.

1. Done: it's ok

2. Done: they are ok

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.