使用Python脚本根据PowerBI中的当前数据集创建新表

import pandas as pd
import pyodbc

conn_str = 'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path_to_powerbi_file'
conn = pyodbc.connect(conn_str)

cursor = conn.cursor()
tables = cursor.tables(tableType='TABLE')

new_table_name = 'new_table'
query = f"CREATE TABLE {new_table_name} (column1 datatype1, column2 datatype2, ...)"
cursor.execute(query)

query = f"INSERT INTO {new_table_name} SELECT * FROM {current_table_name}"
cursor.execute(query)

conn.commit()
conn.close()