Forum Discussion

cristinaojer's avatar
cristinaojer
Frequent Visitor
2 years ago

Can't load data from SQL Server into Lakehouse. Can't add a data destination.

I'm facing some issues when trying to get data from SQL Server database into Fabric Lakehouse. I'm using an on-premises data gateway updated up to it’s latest version. We’ve tried to get this d...
Need Help
v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi cristinaojer 

 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

 

Thanks.

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi cristinaojer 

 

When using Microsoft Fabric Dataflow Gen2 with an on-premises data gateway, you might encounter issues with the dataflow refresh process. The underlying problem occurs when the gateway is unable to connect to the dataflow staging Lakehouse in order to read the data before copying it to the desired data destination. This issue can occur regardless of the type of data destination being used.

The firewall rules on the gateway server and/or customer's proxy servers need to be updated to allow outbound traffic from the gateway server to the following:

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

Please refer to the documentation for more details : Set new firewall rules on server running the gateway

 

For similar issue please refer : Error when trying to create a dataflow gen 2. - Microsoft Fabric Community

 

I hope this information helps.

 

Thank you.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi cristinaojer 

     

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
    Otherwise, will respond back with the more details and we will try to help.

     

    Thanks.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      2 years ago

      Hi cristinaojer 

       

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
      If you have any question relating to the current thread, please do let us know and we will try out best to help you.
      In case if you have any other question on a different issue, we request you to open a new thread.

       

      Thanks.

  • cristinaojer's avatar
    cristinaojer
    Frequent Visitor
    2 years ago

    Hi v-cboorla-msft,

     

    Thank you very much for the response. Gateway admins opened firewall rules and data loading worked fine for DataFlow Gen2! But I'm still having the problem with Copy Activity... I'm waiting for my collegues to update the last version of the gateway and I'll write back to this post with the result

     

    Thanks,