/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 vote206 views1 answer
Creating sqeuence in oracle database
SQL
0 vote343 views1 answer
Dublicate row sql
SQL
1 vote177 views1 answer
Mysql remove last empty newline
SQL
0 vote146 views1 answer
Sql examples from your work
SQL
-1 vote116 views1 answer
How to create script to connect to oracle database and run query
SQL
3 votes215 views2 answers
How to open postgresql in windows
SQL
11 votes174 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote170 views1 answer
Returning with sqlalchemy
SQL
0 vote160 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote156 views1 answer
Alter table fulltext
SQL