🛠️ Scheduled Maintenance | We’ll be undergoing scheduled maintenance and upgrades between 00:00 PST Jan 26th until 00:00 PST Jan 28th. There may be brief interruption of services in that period. We apologize for the inconvenience.

×
The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Failing to connect to an SQL database in Power BI Desktop

Failing to connect to an SQL database in Power BI Desktop

Super Learner
0
Votes
1
Answer

Hello 365DataScience Team,
in your course (Power BI), when trying to reproduce your steps when connecting to SQL Database for the first time, many people gets error:

Details: “Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)”
I have MySQL already installed, but I fail every time when trying to connect.

Also, the first time when trying to connect to an SQL database, the credentials window shows up.
I tried many things, took me 2 hours looking for the solution on the internet and I am stuck at the beginning of the course. For now, I am just hoping to find the solution.

 

Could you address this issue, please? Many people have the same problem.
Best,
Maros Jevocin

1 Answer

365 Team
0
Votes

Hi Maros,

Thank you for reaching out. Looks like you are using the wrong connector to connect to the database. MySQL database is different from SQL database. Please look out for MySQL connector inside Power BI.

Kind Regards,
Dimitar Shutev

Hello Dimitar, thank you for your reply. Later I discovered that there was a MySQL connection. However, I still had some problems. Just now I found out I forgot my credentials. Now that I remembered them, it is working. So, yes, your advice helped, thanks. Also, I had to choose the Database tab on the Credentials popup window. Best, Maros Jevocin

4 weeks