Forum Discussion

MBaldo's avatar
MBaldo
Frequent Visitor
2 years ago
Solved

Issue setting destination on dataflow to Lakehouse, data originating from SQL via data gateway

Hi all,   So we seem to be having issues creating dataflow gen 2 utilising the data gateway in a fabric trial. I can configure the dataflow get 2 to with a connection to the local sql instance fin...
Dataflow
Need Help
  • MBaldo's avatar
    MBaldo
    2 years ago

    Hi there, just an update to this, the issue was caused by the above URL's still being blocked on port 1433. The network guys had incorrectly configured the firewall rules.

     

    Thanks all who looked.

     

    Matt

MBaldo's avatar
MBaldo
Frequent Visitor
2 years ago

Hi there, just an update to this, the issue was caused by the above URL's still being blocked on port 1433. The network guys had incorrectly configured the firewall rules.

 

Thanks all who looked.

 

Matt

  • caomayan's avatar
    caomayan
    Helper I
    2 years ago

    Thanks for the update! so I got the exact same error and asked the network guy to add those endpoints...there should be no more steps for the configuration, right? 

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