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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TheMish
Regular Visitor

connecting to SQL server

Hello, I created a simple test database in order to connect my PowerBI to it. However, i am having issues.

 

Database info:

Server: db4free.net  port is 3306

database name: woodinvillecrime

username: woodinvilleuser

pssword: crimesucks

 

1. I click on Get Data

2. on the server field I fill in db4free.net

3. on the next page I plug on the username and password. I then get the  "we could not authenticate with the credentials provided"  message. what am i doing wrong here ?

I am certain that user id and password are correct. I am able to log in to the db4free.net website and few MySQL data.

 

Can you please tell me what am I missing?

 

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

You should install the MySQl connector for Power BI before attempting to connect. You can find more information here.

 

https://community.powerbi.com/t5/Integrations-with-Files-and/Trying-to-connect-to-MY-SQL-from-Power-...

View solution in original post

Anonymous
Not applicable

You can download the lastest Connector/Net data prvider for Mysql from the official MySql website at https://dev.mysql.com/downloads/connector/net/

View solution in original post

4 REPLIES 4
TheMish
Regular Visitor

image.png

This is the SQL website platform if this helps. 

Thanks,

Anonymous
Not applicable

You can download the lastest Connector/Net data prvider for Mysql from the official MySql website at https://dev.mysql.com/downloads/connector/net/

Thank you guys. it is working now. Much appreciated. 

Anonymous
Not applicable

You should install the MySQl connector for Power BI before attempting to connect. You can find more information here.

 

https://community.powerbi.com/t5/Integrations-with-Files-and/Trying-to-connect-to-MY-SQL-from-Power-...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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