/SQL/How to connect .sql data set to powerbi

How to connect .sql data set to powerbi

import pandas as pd	
import pyodbc 
conn = pyodbc.connect('Driver={SQL Server};'
                     'Server=servername;'
                     'Database=databasename;'
                     'Trusted_Connection=yes;')
cur= conn.cursor()
sqlquery = pd.read_sql_query('SELECT * FROM tablename',conn)
print(sqlquery)

Source: hevodata.com

Similar codes

0 vote173 views1 answer
How to combine rows in sql server procedure
SQL
0 vote147 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote158 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote132 views1 answer
Get who is hired in month in sql
SQL
6 votes154 views1 answer
How to count number of rows in sql
SQL
1 vote176 views2 answers
Mysql add column tinyint default 0
SQL
0 vote140 views1 answer
Sql constarint
SQL
-2 votes156 views1 answer
No module named '_sqlite3
SQL
0 vote152 views1 answer
T-SQL Never ending DELETE
SQL
1 vote142 views1 answer
Oracle start job
SQL