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

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