Forum Discussion

Scott_Powell's avatar
Scott_Powell
Icon for Advocate IV rankAdvocate IV
2 years ago

Gen2 Dataflow to Warehouse - really slow performance

Hi, I'm hitting an issue with loading data from on-prem SQL server to a Fabric Warehouse using dataflows gen2. I'm only moving 34k rows (about 30 columns), and it's taking almost 13 minutes to do thi...
Tips and Tricks
cpshort7186's avatar
cpshort7186
Icon for Advocate I rankAdvocate I
1 year ago

I"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's avatar
miguel
Icon for Community Admin rankCommunity Admin
1 year ago

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