How to Connect to Power BI Service Datasets and Pull Data Using Python Locally (Outside Fabric)

import adodbapi

# Connection string (edit table and workspace as needed)
conn = adodbapi.connect("Provider=MSOLAP.8; \
    Data Source='powerbi://api.powerbi.com/v1.0/myorg/Testws'; \
    Initial Catalog='db1'")

# Create cursor
cursor = conn.cursor()

# Replace 'YourTableName' with a real table name in your data model
dax_query = "EVALUATE 'table'"

print("Querying table: table")
cursor.execute(dax_query)

# Fetch column names
columns = [column[0] for column in cursor.description]
print("Columns:", columns)

# Fetch all rows
rows = cursor.fetchall()
for row in rows:
    print(row)

# Close the connection
cursor.close()
conn.close()

 This approach is working for me
You can mark this as a solution 
Thanks