Dataflows Gen2 writing data into to a warehouse in another workspace

Hi saradada-xtivia ,

Below are some of my thoughts on your question:

1. Writing Data into a Warehouse in Another Workspace:

Currently, Dataflow Gen2 does not support writing data directly into a Warehouse located in a different workspace. This is a known limitation for performance reasons. The message you received, "For performance reasons, only Warehouses in the current workspace are shown," confirms this limitation.

2. Using Shortcuts to Work Around the Limitation:

While creating a Shortcut in Workspace A's Lakehouse that points to the Warehouse in Workspace B allows you to see and select the table, it seems this approach is not fully supported for publishing Dataflows. The error you're encountering, "Mashup Exception Expression Error," suggests there might be an issue with the Power Query transformations or the way the Shortcut is being handled.

3. You can look at these documents below:

Solved: Re: DataFlow with DataWarehouse in other Workspace... - Microsoft Fabric Community

Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn

So I think it's best to keep the data flow and the repository in the same workspace as far as I can tell. This will avoid the problems you are experiencing. Also you can keep an eye on Data Factory updates as they may introduce new features or improvements that will solve this limitation in the future.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.