topic Re: Dataflow Gen2 - Data Destination: Fabric Datawarehouse in Dataflow

Dataflow Gen2 - Data Destination: Fabric Datawarehouse

chris__1 — Tue, 08 Aug 2023 09:49:19 GMT

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

Re: Dataflow Gen2 - Data Destination: Fabric Datawarehouse

miguel — Thu, 03 Aug 2023 14:43:27 GMT

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

Re: Dataflow Gen2 - Data Destination: Fabric Datawarehouse

chris__1 — Fri, 04 Aug 2023 12:17:40 GMT

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!