How to connect mysql and fetch data using python

[Anonymous]

Hello, i need your help, i need to connect and fetch data from mysql server. I executed this code in visual studio code and works fine, but in power bi only connect but not fecthed the data.

import MySQLdb

myConnection = MySQLdb.connect(host='xx.xxx.xxx.x', user='xxx', passwd='xxx', db='xxx')

try:

cur = myConnection.cursor()

cur.execute("SELECT * from ETL_Python.countries")

rows = cur.fetchall()

desc = cur.description

print(desc[4][0],desc[6][0],desc[7][0],desc[9][0],desc[22][0],desc[23][0])

for row in rows:
print(row[4],row[6],row[7],row[9],row[22],row[23])

finally:

myConnection.close()

Best regards.

[Anonymous]

Hi @Anonymous ,

Here' the article about using python to filter data in power query.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CNENFRNL]

I didn't see the point bothering to use python in your senario. Value.NativeQuery() in Power Query is an out-of-the-box function to fetch data with intact sql.