Why does the DataWarehouse sink option disappear in Fabric pipeline copy settings?

[abhidotnet]

I’ve been troubleshooting copy activities from SQL Server into Fabric Warehouse. I noticed that in the pipeline JSON there are two possible sink types:

• "type": "DataWarehouseSink"

• "type": "SqlServerSink"

For some reason, the option to select DataWarehouse as the sink has disappeared from the GUI. When the pipeline defaults to SqlServerSink, the copy fails. If I manually edit the JSON to set "type": "DataWarehouseSink", the pipeline runs successfully and data is copied into the destination table.

My question is: what enables or causes the DataWarehouse sink setting to disappear from the GUI? Is this a known limitation, a configuration issue, or something that changed recently in Fabric?

Thanks in advance for any guidance or clarification.

[Ugk161610 · Accepted solution]

Hi @abhidotnet ,

We’ve seen this happen recently too, and it’s a little confusing because nothing in the workspace or pipeline settings actually changes — the DataWarehouse sink option simply disappears from the UI, even though the backend still supports it. What you’re seeing is expected for the moment.

What’s going on is that the Fabric UI doesn’t always recognize Warehouse as a supported sink when the linked service or dataset isn’t fully refreshed, or when the workspace has been updated in the background. When that happens, the UI falls back to showing SqlServerSink, even though that sink can’t write to a Fabric Warehouse. That’s why your copy fails unless you manually change the JSON back to "DataWarehouseSink", which still works perfectly once executed.

This isn’t a configuration mistake on your side. It’s more related to a recent UI change — the Warehouse sink option sometimes drops out of the dropdown, even though the pipeline runtime still supports it. Once the UI gets into that state, it won’t reappear until Microsoft refreshes something on the service side or the workspace naturally updates again.

For now, the manual JSON edit is the only reliable workaround when the GUI doesn’t show the Warehouse option. The backend still honors DataWarehouseSink, so your pipeline runs correctly once you force it.

Hopefully Microsoft brings the UI and runtime back in sync soon, because the disappearing sink option is definitely confusing when everything else is configured correctly.

– Gopi Krishna