/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 vote268 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote274 views3 answers
Sql parenthetical expression examples
SQL
0 vote266 views1 answer
Mysql c commands
SQL
18 votes258 views3 answers
Find column name in database
SQL
0 vote256 views1 answer
How to select only id where is not in column mysql
SQL
17 votes269 views4 answers
Mysql remove ubuntu
SQL
1 vote258 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote244 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote250 views1 answer
How to put is null in where in clause
SQL
0 vote249 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL