Forum Discussion

chris__1's avatar
chris__1
Advocate II
3 years ago

Dataflow Gen2 - Data Destination: Fabric Datawarehouse

Hello!

 

Is there a known issue when choosing a Fabric Datawarehouse as data destination for a Fabric Dataflow Gen2?

 

I've been trying multiple times to set a Fabric Datawarehouse as destination for a Dataflow - it always fails. 

However when choosing a Fabric Datalake as destination it works flawless (same Dataflow, no changes besides the destination: Lake instead of Warehouse!).

 

If someone could look into this it would be highly appreciated!

 

Session ID: e8fcbf9d-c989-4b50-b4c5-7fade9b3d2d7

Request ID: 6076833a-3313-4434-ae2f-da5c49350208

Dataflow ID: 909a3834-e245-4aac-900a-948f8533dd0c

Dataflows
Need Help

2 Replies

  • miguel's avatar
    miguel
    Community Admin
    3 years ago

    Hi!

    Could you please help us by answering a few questions?

    • Are you able to repro this behavior in other workspaces? 
    • Does your dataflow uses a Gateway?

    I'd also highly recommend reaching out to our support team so you can engage with an engineer and take a closer look at your scenario. You can raise a support ticket using the link below:

    https://support.fabric.microsoft.com/support

     

    • chris__1's avatar
      chris__1
      Advocate II
      3 years ago

      Hi miguel 

       

      regarding your questions:

       

      1. yes, I created a new workspace  and can reproduce the error (Session ID: d875435f-246f-45ea-b5cf-cade0aaa69fe)

      2. No Gateway should be involved. The datasources for the Dataflow Gen2 are one one hand Dataflows from a existing Power BI Workspace (Source = PowerPlatform.Dataflows) and on the other hand a table from a Fabric Datawarehouse.

       

      Please let me emphasize again, that if I change the destination to a Fabric DataLake instead of a Fabric DataWarehouse (and do not change anything else!) then the Dataflow Gen2 works fine and the data gets pushed to that destination!