Connect Fabric warehouse in Azure Sql server

Question

I need assistance with querying a Microsoft Fabric Warehouse using Azure SQL Server. I want to perform join operations between tables in Azure SQL Database and Fabric Warehouse. I have explored options such as linked servers however it doesn't support, but I am looking for the best approach and need guidance on implementation. Please provide support or any relevant documentation on how to achieve this integration.  

Answer 1

Hi Chandu R •,

Welcome to Microsoft Q&A forum.

As I understand, you want to Connect to Microsoft Fabric Warehouse and Azure SQL Server to establish some mapping.

Let us know if our understanding is correct.

You can try using Data Factory and connect to both, then create mapping in Data Factory for transformations.

Refer: https://learn.microsoft.com/en-us/azure/data-factory/connector-microsoft-fabric-warehouse?tabs=data-factory

https://learn.microsoft.com/en-us/azure/data-factory/connector-sql-server?tabs=data-factory

Hope this helps. Let us know if you have queries.

Thanks.

Answer 2

Unfortunately you cannot directly query fabric warehouse from Azure SQL database as external tables/elastic query doesn't support AD authentication and only SQL auth.

there would be 2 ways to cross query the data:

1. leverage dataflow Gen 2 would Azure SQL database and Fabric warehouse and merge/append etc via Power query transformations
2. establish Azure SQL database mirroring and then cross query via shortcuts/fabric warehouse