Dataflow Gen2 cant connect to data warehouse

Hi mandania ,

Thanks for using Fabric Community.
As I understand due to performance reasons, dataflow gen2 is only showing Warehouse in current workspace.

In your scenario I can suggest 2 options -

Option 1: Use only Dataflow Gen2 
Create Dataflow Gen 2 in the workspace where the destination warehouse is located.

Option 2: Use Copy Activity along with DataflowGen2
If you are planning to create Dataflow Gen2 in Workspace A. You can create a temp warehouse in that Workspace A and publish the Dataflow Gen2. Now create a pipeline with DataFlow Gen2 and CopyActivity.

With the help of Copy Activity you can send data from Warehouse A (present in Workspace A) to Warehouse B (present in Workspace B)

Hope this is helpful. Please do let me know incase of further queries.

Hi mandania ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

Hi mandania ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks