topic Re: Linked Server from On Prem SQL Server to Fabric SQL Endpoint in Data Warehouse

Linked Server from On Prem SQL Server to Fabric SQL Endpoint

swamysri1 — Thu, 10 Oct 2024 14:52:40 GMT

Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn

Linked server connections from SQL Server are not supported.

From this link, Its saying Linked Server Connections from SQL Server are not supported.

Can someone confirm. We would like to create Linked Server from On Prem SQL Server to Fabric SQL Endpoint. To query the data from On Prem SQL Server tables, Fabric tables in same query window.

Given in Fabric, Landing/Extract tables are in different workspace. Target tables Dim, Facts are in different workspace. Cross workspace querying is not allowed , need to see the option of Linked Server.

Also for Extract layer, where data is coming from SQL Server on prem, Oracle DB, Sybase DB etc. SQL Server allows Linked server for On prem, so looking if Fabric Endpoint also can be querying with Linked server for validations.

Re: Linked Server from On Prem SQL Server to Fabric SQL Endpoint

Anonymous — Fri, 11 Oct 2024 06:01:42 GMT

Hi swamysri1,

In fact, this link is the official document about the feature.
If you want to achieve these not supported features, I'd like to suggest you submit an idea for this requirement.

Microsoft Fabric Ideas

Regards,

Xiaoxin Sheng

Re: Linked Server from On Prem SQL Server to Fabric SQL Endpoint

swamysri1 — Fri, 11 Oct 2024 21:16:39 GMT

created a new idea

Microsoft Idea