cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TheMish Frequent Visitor
Frequent 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

Accepted Solutions

Re: connecting to SQL server

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-...

C_Jiang Regular Visitor
Regular Visitor

Re: connecting to SQL server

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

4 REPLIES 4
TheMish Frequent Visitor
Frequent Visitor

Re: connecting to SQL server

image.png

This is the SQL website platform if this helps. 

Thanks,

Re: connecting to SQL server

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-...

C_Jiang Regular Visitor
Regular Visitor

Re: connecting to SQL server

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

TheMish Frequent Visitor
Frequent Visitor

Re: connecting to SQL server

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

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 293 members 3,019 guests
Please welcome our newest community members: