On-prem SQL Sever to Farbic · Learn Microsoft Fabric

Aug '24 (edited) • Technical

On-prem SQL Sever to Farbic

I have an on-premises sql server and I would like to be able to query it in azure/fabric. How can I do that with the minimum latency possible? I tried to download and install the on-premises datagateway which I configured on fabric side as well. But the only possibility that I see is to get data through a dataflow gen 2, resulting in a lakehouse table. After some testing I see that this table doesn't have like data unless the powerquery is refreshed. Is there another way to make this connection as seemless and no-copy as possible?

5 comments