Forum Discussion
Lakehouse Connection issue using SQL Endpoint
Hi v-nmadadi-msft , 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 Pratik_0527
have you done this?
Navigate to your app registration in the Azure Portal.
2. Under API permissions, click + Add a permission → Microsoft APIs → Power BI Service.
3. Select delegated or application permissions (e.g., `Dataset.ReadWrite.All` or `Reports.Read.All`, depending on your use case).
4. Click Add permissions and have an admin grant tenant-wide consent
Hi nilendraFabric we do have this permission setup present in Azzure. Also we are not using Power BI. its a C++ driver code.