/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

14 votes155 views4 answers
Online sql compiler
SQL
0 vote139 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote119 views1 answer
Ms sql unique
SQL
0 vote132 views1 answer
Restore backup "text" postgresql command line
SQL
5 votes97 views1 answer
Copy table from one database to another mysql
SQL
0 vote96 views0 answer
SQL
0 vote156 views1 answer
Sql out file formate
SQL
3 votes136 views1 answer
DB: in eloquent using sql
SQL
2 votes137 views2 answers
Useradd postgres
SQL
0 vote144 views1 answer
Mysql shell set time_zone
SQL