Forum Discussion
Create a linked server connection from on-prem SQL Server to Fabric SQL Endpoint
Microsoft EmployeeHi BobChauvin
Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help.
Advocate IIIHi, I'm having the same use caseand have not been successful in finding any solutions for this matter. The links provided did not highlight anything that would be useful for connecting "linked servers" specifically to MS Fabric. Is there anything I'm missing?
I'm not sure it's possible, per the documentaion here: Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn "...Linked server connections from SQL Server are not supported...."
Note, for other connections I have been using the following:
Driver/Provider=MSOLEDBSQL19.1;
Authentication=ActiveDirectoryServicePrincipal;
And the user and datasource values will come from that fabric admin.
User ID=someguidstringhere;
Initial Catalog=DatabaseName;
Data Source=someguidstringhere.datawarehouse.pbidedicated.windows.net;
The following article does have info on getting a SQL connection string Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn
