Answers for "how to connect power bi desktop with rdp sql server"

SQL

0

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)

Posted by: Guest on November-24-2020

Source

Code answers related to "how to connect power bi desktop with rdp sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#