Reply
Frequent Visitor
Posts: 5
Registered: ‎10-08-2018
Accepted Solution

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?

 


Accepted Solutions
Member
Posts: 76
Registered: ‎05-30-2018

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

View solution in original post

Regular Visitor
Posts: 25
Registered: ‎08-01-2018

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/

View solution in original post


All Replies
Frequent Visitor
Posts: 5
Registered: ‎10-08-2018

Re: connecting to SQL server

image.png

This is the SQL website platform if this helps. 

Thanks,

Member
Posts: 76
Registered: ‎05-30-2018

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

Regular Visitor
Posts: 25
Registered: ‎08-01-2018

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/

Highlighted
Frequent Visitor
Posts: 5
Registered: ‎10-08-2018

Re: connecting to SQL server

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