Forum Discussion

vivien57's avatar
vivien57
Super User
2 years ago
Solved

DataFlow with DataWarehouse in other Workspace Error

Hello,

I have a dataflow in one workspace that I want to configure with a DataWarehouse destination in another workspace.

However, I have the following warning:

 

"Due to performance reasons, only Warehouses in the current workspace are shown."

Has anyone had this problem before?

Normally I should be able to write to any Data Warehouse (it doesn't matter which workspace, as long as I have the rights).

Have a nice day,

Dataflows
Need Help
  • v-cboorla-msft's avatar
    v-cboorla-msft
    2 years ago

    Hi vivien57 

     

    Apologies for the issue you are facing here.

     

    Configuring a Dataflow in one workspace with a Data Warehouse destination in another workspace in Microsoft Fabric isn't possible at the moment. This is a expected behaviour and the banner you highlighted stated as well, only warehouses in the current workspace are shown.

     

    I hope this helps. Please do let us know if you have any further questions.

6 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi vivien57 

     

    Thanks for using Fabric Community.
    At this time, we are reaching out to the internal team to get some help on this.
    We will update you once we hear back from them.


    Thanks

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi vivien57 

       

      Apologies for the issue you are facing here.

       

      Configuring a Dataflow in one workspace with a Data Warehouse destination in another workspace in Microsoft Fabric isn't possible at the moment. This is a expected behaviour and the banner you highlighted stated as well, only warehouses in the current workspace are shown.

       

      I hope this helps. Please do let us know if you have any further questions.

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Microsoft Employee
        2 years ago

        Hi vivien57 


        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
        In case if you have any resolution please do share that same with the community as it can be helpful to others.
        Otherwise, will respond back with the more details and we will try to help.


        Thanks

  • Alexandernoclue's avatar
    Alexandernoclue
    Frequent Visitor
    3 months ago

    Hi, I actually have a work around for it.
    You could create the Dataflow Gen2 in the target workspace (where you want to save the data) and then you are able to select a source from a different workspace. With this way you are not limited to the worksapce boundries. 🙂