topic Re: Query Federation in Fabric in Data Warehouse

Query Federation in Fabric

piyushpp — Fri, 04 Apr 2025 15:58:00 GMT

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 query the OLTP databases (in Azure, AWS and on-prem) from Fabric Warehouse or Lakehouse? Additionally, does Fabric support Polybase today (like this)?

If these are available then how? If not, there are in the roadmap? Any response is appreciated.

Thank you.

Re: Query Federation in Fabric

nilendraFabric — Fri, 04 Apr 2025 18:38:44 GMT

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

Re: Query Federation in Fabric

v-prasare — Mon, 21 Apr 2025 11:41:33 GMT

Hi piyushpp,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

nilendraFabric , Thanks for your promt response

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query