Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
MarkBurgess
Helper I
Helper I

Fabric integration with Azure SQL database

We are currently looking into moving our data warehouse to Fabric but we have some external data in an Azure SQL database. We'd like to integrate this data with Fabric without having to copy or move it. Is there a way to create a 'shortcut' (or equivalent of a linked server) in a Fabric Lakehouse or Warehouse to allow you to directly query the data that is in the Azure SQL database?

 

The only way I can think to query the same data from both environments is to store the data in ADLS and set it up as an external table in SQL. However the SQL database is running an established system that we can't change. 

 

Thanks

 

  

2 ACCEPTED SOLUTIONS

It has been released (public preview) yesterday!

More info: 
Announcing the Public Preview of Mirroring in Microsoft Fabric | Microsoft Fabric-blog | Microsoft F...

Mirroring - Microsoft Fabric | Microsoft Learn

 

 

 

 

Cheers, Edgar Walther
ITsmart BI and Analytics consultant

View solution in original post

4 REPLIES 4
AndyDDC
Super User
Super User

Hi @MarkBurgess when do you need this up and running by? Mirroring in Azure SQL is on the Fabric roadmap but not available yet.  There's no shortcut support for sql databases, so it may be that you'd need to incrementally export the data from the sql database to (as you say) azure data lake and then shortcut into fabric from there

Thanks @AndyDDC, good to know that mirroring is on the roadmap. Is there an approximate date?

It has been released (public preview) yesterday!

More info: 
Announcing the Public Preview of Mirroring in Microsoft Fabric | Microsoft Fabric-blog | Microsoft F...

Mirroring - Microsoft Fabric | Microsoft Learn

 

 

 

 

Cheers, Edgar Walther
ITsmart BI and Analytics consultant

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.