Forum Discussion

AnthonyGenovese's avatar
AnthonyGenovese
Icon for Resolver III rankResolver III
3 years ago
Solved

Named Pipe Error - Cant load data into Lakehouse

I have been trying to load a single table from on prem Sql Server to a newly created Lakehouse. The data loads fine from the gateway. We see a success message and data in the staging artifact.  Howev...
Dataflows
Need Help
  • AnthonyGenovese's avatar
    AnthonyGenovese
    3 years ago

    Issue was resolved after July 2023 gateway application was published and installed. 

SidJay's avatar
SidJay
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Is your Gateway server / proxy configured to allow the following?

    • Protocol: TCP
    • Endpoint: *.datawarehouse.pbidedicated.windows.net
    • Port: 1433

If not, could you please see if applying those configuration settings resolves the issue?

 

Based on the error you shared as well as your point #7, it sounds like the Gateway server is unable to connect to the Warehouse instance that is used for compute against staged data.

 

Thanks

  • AnthonyGenovese's avatar
    AnthonyGenovese
    Icon for Resolver III rankResolver III
    3 years ago

    Where do I apply this configuration in the gateway application?

    • miguel's avatar
      miguel
      Icon for Community Admin rankCommunity Admin
      3 years ago

      This would be configurations on your own network where the application is running as the application doesn't control such network settings at the environment level.

  • AnthonyGenovese's avatar
    AnthonyGenovese
    Icon for Resolver III rankResolver III
    3 years ago

    Still seeing the issue. Our IT department has confirmed that the firewall is open and they see data moving out. Any other suggestions?