- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create a linked server connection from on-prem SQL Server to Fabric SQL Endpoint
Hey all. I'm trying to create a linked server connection from on-prem SQL Server to Fabric SQL Endpoint. I saw one other post here that was "inconclusive". I can use SSMS to connect to the SQL Endpoint. And, also connect via another app using the Microsoft OLE DB Driver 19 for SQL Server.
There are no great examples on how to do this, and my simple attempt failed with a general error. Followed general insturctions here, but there are no examples using the SQL Connection String from the Fabric SQL Endpoint. https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-a...
Is this supported, or to-be supported?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @BobChauvin
Apologies for the delay in the response.
As I understand that you are trying to create a linked server connection from on-prem SQL Server to Fabric SQL Endpoint.
The below procedure might help you to resolve your ask.
In order to connect from on-prem SQL server to Fabric, you need to install an on-premises gateway. Please find the related documentation - Install and configure an on-premises data gateway
For server connection from on-prem SQL server to Microsoft Fabric.
For more details please refer :
On Premise SQL Server 2022 Data into Microsoft Fabric
Getting On-Premises SQL Server Data to Fabric Lakehouse
I hope this information is helpful. Please do let us know if you have any questions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you. I'll have to review and will respond asap.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, 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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI @BobChauvin
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @BobChauvin
Thanks for using Microsoft Fabric platform and posting your question here.
I have escalated this to our internal team and will definitely come back to you if I get an update. Please continue using Fabric Community for help regarding your queries.
Appreciate your patience.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-03-2025 06:13 AM | |||
03-17-2025 10:13 AM | |||
03-08-2024 12:24 AM | |||
02-05-2025 01:24 AM | |||
01-19-2025 06:36 PM |
User | Count |
---|---|
23 | |
15 | |
8 | |
7 | |
2 |
User | Count |
---|---|
31 | |
25 | |
22 | |
15 | |
12 |