Forum Discussion

piyushpp's avatar
piyushpp
New Member
1 year ago
Solved

Query Federation in Fabric

Hello,   I don't want to bring all the data in OLTP databases to Fabric OneLake (via Mirroring). I know about Data Factory but looking for query federation option. Is there a way to connect and que...
data warehouse
Warehouse
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    Hi piyushpp 

     

    Direct query federation for external OLTP databases is not yet available in Microsoft Fabric.

     

    Polybase does not currently support direct integration with Fabric Lakehouse Delta tables or Warehouse tables

     

    In fabcon 2025 the focus was around bringing more sources through mirroring , there was no mention about federation query. 

    but worth raising it as an idea on Fabric portal

     

    if this helps please give kudos and accept the answer 

nilendraFabric's avatar
nilendraFabric
Icon for Super User rankSuper User
1 year ago

Hi piyushpp 

 

Direct query federation for external OLTP databases is not yet available in Microsoft Fabric.

 

Polybase does not currently support direct integration with Fabric Lakehouse Delta tables or Warehouse tables

 

In fabcon 2025 the focus was around bringing more sources through mirroring , there was no mention about federation query. 

but worth raising it as an idea on Fabric portal

 

if this helps please give kudos and accept the answer