Forum Discussion
Fabric Lakehouse connection Getting Rerouted
Hi v-prasare , We found the solution for the issue. For lakehouse, the connection gets rerouted to some different URL. Initially we were tokenizing it and trying to connect to it, but the trick is you need to perform socket , prelogin on the original end point and "send the redirected URL to the login stage" while using the TDS protocol. PFB sample :
original Sql end point : nkttul5irfuejgeufneefoktjm-obtyxdfizvlura7ao2yincxurq.datawarehouse.fabric.microsoft.comRedircted URL : pbipneu9-northeurope.pbidedicated.windows.net\ABCDUL5IRFUEJGEUFNEEFOKTJM-CCSJOZJPH6FE5GFNZMCN4ILWLA-dw:1433
Existing code logic trying to connect : pbipneu9-northeurope.pbidedicated.windows.net
Hi,
we are looking into it, will post answer once we are done here.
Thanks,
Prashanth Are
MS Fabric community support
Hi v-prasare ,
Thank for reverting, We are stuck at a point and some quick guidance is really appreciated
Hi Pratik_0527,
In the context of Microsoft Fabric, especially when using OAuth and MSAL for authentication, the system might redirect connection to a different endpoint to ensure optimal performance and security. This is particularly true when connecting to the SQL analytics endpoint of a Lakehouse, which is designed to handle SQL queries over Delta tables. The system may reroute connections to balance loads or to direct them to the appropriate compute resources.
refer to below docs for more info:
https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-sql-analytics-endpoint
https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity
Thanks,
Prashanth Are
MS Fabric community support
Thanks for the reply Prashanth,
We raised this issue with the Fabric team and currently checking with them on how to handle this rerouting issue and establish the connection.