Fabric connection in TimeXtender 20.10.74.64

Hi ​@annfoss , 

I know a ODBC connection is a option. But not sure if there are any other options. 

Hi ​@bas.hopstaken  The “Generic ODBC Data Source” ? 

​@annfoss  The Fabric SQL analytics endpoint only accepts Entra ID authentication, and the 20.10 native SQL data source does not currently support this.

As a workaround, you could try to use OLEDB Any Source data source with an external driver that supports Entra ID.

1. Install Microsoft OLE DB Driver 19 for SQL Server (MSOLEDBSQL19) on the machine running the ODX/BU service
2. Add it as an Any Source OLE DB (or Any Source ADO.NET) data source, pointing at the Lakehouse's SQL endpoint.
3. Choose an Entra auth mode the driver supports: Entra password (the user can't have MFA), or service principal. Interactive/MFA won't work for scheduled executions.

Please note that the above is a workaround, and connecting to Microsoft Fabric OneLake as a data source is not officially supported in 20.10

Please see article regarding the data source supported in TDI: 

Please also see related discussion here:

Hi ​@annfoss ,

Not sure what type of storage you’re trying to connect to in Fabric? Maybe the Parquet connector is an option as well.

If you’re connecting to a Fabric Warehouse, you should be able to use the SQL connector, although it does not support service principal authentication. The ODBC SQL Server connection does support service principal authentication.

A new ODBC driver is available as well (although it’s still in preview): Microsoft ODBC Driver for Microsoft Fabric Data Engineering - Microsoft Fabric | Microsoft Learn