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

jlakshminaraya Could you please let me know what your endpoints are in your firewall rules?

 

This?

 

  • Endpoints: *.datawarehouse.pbidedicated.windows.net, *.datawarehouse.fabric.microsoft.com, *.dfs.fabric.microsoft.com

 

 

Or something else? like an additional endpoint perhaps that's not listed in the docs?