cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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-...

View solution in original post

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/

View solution in original post

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

View solution in original post

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/

View solution in original post

Highlighted
TheMish Frequent Visitor
Frequent Visitor

Re: connecting to SQL server

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

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

Users Online
Currently online: 283 members 3,129 guests
Please welcome our newest community members: