Forum Discussion

jlakshminaraya's avatar
jlakshminaraya
Frequent Visitor
2 years ago

Data read from On-prem SQL server to Fabric Satawarehouse is slower through Dataflow GEN2

Hello -  I noticed that, data read from On-prem SQL server to Fabric Datawarehouse is slower than SSIS approach.  Here are more details for better understanding about the issue:    With SSIS appr...
Dataflows
jlakshminaraya's avatar
jlakshminaraya
Frequent Visitor
2 years ago

I have one dataflow only. Which is working firn for me

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
2 years ago

That's amazing! Why do I need to use 2 DFs???  I don't get it.  Did you also set your firewall rules to this or do you have different endpoints?

 

  • Protocol: TCP
  • Endpoints: *.datawarehouse.pbidedicated.windows.net, *.datawarehouse.fabric.microsoft.com, *.dfs.fabric.microsoft.com
  • Port: 1433

 

That's straight from the documentation... but if the docs are not in sync with some new changes, then that might explmain perhaps I am missing an endpoint?

 

source: On-premises data gateway considerations for data destinations in Dataflow Gen2 - Microsoft Fabric | Microsoft Learn