Forum Discussion
Advocate IVGen2 Dataflow to Warehouse - really slow performance
Any update on this issue? Im trying to load data with Knime ETL tool to the Fabric warehouse but it is incredebly slow..
Advocate II"m trying to do the same with Alteryx and still experiencing extreme performance issues. Data output is just a few thousand rows. Job runs in 9 sec without trying to write to Fabric Warehouse, and takes 35min plus to run loading to warehouse. Sometimes it just fails.
- miguel
Community Admin
If you're trying to perform this with a different tool other than Dataflows, and you've noticed that the bottleneck is loading the data to the warehouse, definitely try reaching out to our support team or post this question in the Data Engineering community who oversee any topics directly related to the data warehouse
- cpshort7186
I don't seem to have the ability to submit support requests. With all the AI tools available I with Microsoft would do a better job of summarizing issues and consolidating these problems across various forums... I shouldn't have to re-post issues multiple times, but I did it anyways: Poor ODBC insert performance in Warehouse - Microsoft Fabric Community
- miguel
Here's the link to the supports page:
https://support.fabric.microsoft.com/support
if you're having issues creating a support ticket, I'd recommend getting in touch with your admin so they can create it on your behalf. This would be the route where our support team can tell you exactly what could be happening and what ways to address the scenario.
I can see that you've created another thread in the data warehouse forum. That's great! Typically we would move entire topics between forums, but given that this was a reply and not a newly created topic, as it's quite specific to external tools and not Dataflow Gen2, we couldn't just move the reply and create a new topic on your behalf. In cases like this we encourage users to post their full scenarios as a new topic in the most appropriate forum.
Nevertheless, I still encourage you to go through the support route as it's the route where you can engage with our team directly to get to the bottom of the situation.
best!
