Microsoft ODBC Driver for Data Engineering Failed to Create Spark Session

Hi Andy_JH ,

Thank you for reaching out to the Microsoft Community Forum.

The error indicates, the ODBC driver can’t locate one of the Fabric objects it needs to open a Spark session, because a GUID (WorkspaceId/LakehouseId) or region/endpoint in the DSN/connection string is wrong or mismatched.

Please try below things to fix the issue.

1. Please check WorkspaceId and LakehouseId the GUID is correct or not.

2. Please check fabric workspace’s region and the DSN’s configured endpoint/region must match. Ensure you are logging into the same Entra tenant that owns the workspace when using Interactive auth.

3. Please check you have access to the specific Lakehouse item, if item-level permissions are used.

4. Check your ODBC driver, TDS/SQL endpoint (ODBC Driver 18/SQL Server), used for Warehouse and Lakehouse SQL analytics endpoint. Spark/Livy ODBC, used to run Spark SQL via Livy against a Lakehouse (Data Engineering).

5. Delete the old DSN and re-enter values. minor naming/format variations can cause issues.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh