Connect SQL Server to Power BI Using Custom Scripts

[Dnyaneshwar_21]

I am trying to connect SQL Server to Power BI Using Custom Scripts,During this facing issue.
Regarding please check below Details - 
Python Script - 

import pandas as pd   

import pyodbc

conn = pyodbc.connect('Driver={SQL Server};'

                     'Server= ServerName ;' - Mentioned Correctly

                     'Database=Test;' - Mentioned Correctly

                     'Trusted_Connection=yes;')

cur= conn.cursor()

sqlquery = pd.read_sql_query('SELECT * FROM Customers',conn) - Mentioned Correctly

print(sqlquery)

Note - I have already Installed libaries which are needed.

pip install pyodbc

pip install pandas

pip install matplotlib

[v-luwang-msft · Accepted solution]

Hi @Dnyaneshwar_21 ，

You can refer to the following official Microsoft link for a detailed description of the error and the solution, as the situation is caused by your specific situation, and you can follow the steps in the link to troubleshoot it,refer:

https://learn.microsoft.com/en-us/troubleshoot/sql/connect/network-related-or-instance-specific-erro... 

Best Regards

Lucien