Hi, i'm trying to connect to Fabric Lakehouse with SQL endpoint. Here's the example code:
import pyodbc
import struct
import msal
# Configuración de la aplicación
TENANT_ID = "xxxxxxxxxxxxxxxxxxxx"
CLIENT_ID = "xxxxxxxxxxxxxxxxxxxxxxx"
CLIENT_SECRET = "xxxxxxxxxxxxxxxxxxxx"
# URL de autoridad (directorio)
AUTHORITY = f"https://login.microsoftonline.com/{TENANT_ID}"
# Scope (debe terminar en .default para client_credentials)
SCOPE = ["https://graph.microsoft.com/.default"]
# Crear la aplicación confidencial
app = msal.ConfidentialClientApplication(
CLIENT_ID,
authority=AUTHORITY,
client_credential=CLIENT_SECRET
)
# Obtener el token
result = app.acquire_token_for_client(scopes=SCOPE)
if "access_token" in result:
print("✅ Token obtenido:")
print(result["access_token"])
else:
print("❌ Error al obtener token")
print(result.get("error"))
print(result.get("error_description"))
access_token = result["access_token"]
# Configuración
SQL_SERVER = "xxxxxxxxxxxxxxxxxxxxxxxxxx" # Copiado del endpoint SQL
SQL_DATABASE = "BD_Cluster_Estrategia_Consumo"
# Parámetros de conexión ODBC
conn_str = (
f"Driver={{ODBC Driver 18 for SQL Server}};"
f"Server={SQL_SERVER};"
f"Database={SQL_DATABASE};"
f"Encrypt=yes;"
f"TrustServerCertificate=no;"
)
# Conectar con el token
conn = pyodbc.connect(conn_str, attrs_before={1256: access_token},autocommit=True)
cursor = conn.cursor()
cursor.execute("SELECT TOP 10 * FROM sys.tables")
for row in cursor.fetchall():
print(row)
But always throws this error:
pyodbc.Error: ('HY000', 'The driver did not supply an error!')
I think it could be an issue related to the app registration API permissions, but even if i got all the possible permissions to Power BI Service, the connection still doesn't work. I also think it could be related with the fact i'm using a trial account and it needs a paid one. Does anybody know something about that? What permissions the app registration need? I need to use a paid account?
