How to insert Power BI Dataset to SQL directly using python and Automation

In this video we explored How to Power BI Data to load into SQL using Python Script and how to automate recurring basis.
please follow the python script used in this video.
----------------------------------------------
Check Database Connection Script:-

from logging import exception
from sqlalchemy import create_engine
#create variables for pass below connection string
username='root'
password=1234
database='test_db'
#localhost or 127.0.0.1
server='localhost'
engine = create_engine(f'mysql+pymysql://{username}:{password}@{server}/{database}')
#db connection success or not will check
try:
engine.connect()
print('database connected')
except:
print('database not connected')
---------------------------------------------------------------------------------------------------------------------------------------
Script used in Power BI Report in Power Query window.

# 'dataset' holds the input data for this script
from logging import exception
from sqlalchemy import create_engine
import pandas as pd
#create variables for pass below connection string
username='root'
password=1234
database='test_db'
#localhost or 127.0.0.1
server='localhost'
engine = create_engine(f'mysql+pymysql://{username}:{password}@{server}/{database}')
df=pd.DataFrame(dataset)
df.to_sql('invoices',engine,if_exists='replace')