Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
AnthonyGenovese
Resolver III
Resolver III

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.  However, the next step that writes the data to the Lakehouse fails everytime.  (Error Message and screen shots below). We have tried the following

1) Created a new Workspace & Lakehouse just in case something happened with the automatically created artifacts.

2) Removed all spaces and special characters from table and column names

3) Double checked all data types are correct

4) Tried multiple different tables, some with many rows, some with only 1 row.

5) We tried creating the dataflow from the Lakehouse & from the New Dropdown button in the workspace

6) We tried using the default destination connection and changing the destination connection.

7) We did try creating two data flows, one that is just a dataflow with no destination. And then a second that used that dataflow as a source and then created a destination. This actually worked. However, this seems horribly inefficient

 

AnthonyGenovese_0-1688661139431.png

 

Mashup Exception Error Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Details: DataSourceKind = Lakehouse;DataSourcePath = Lakehouse;Message = A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server);ErrorCode = -2146232060;Number = 53;Class = 20

 

 

 

1 ACCEPTED SOLUTION
AnthonyGenovese
Resolver III
Resolver III

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

View solution in original post

7 REPLIES 7
AnthonyGenovese
Resolver III
Resolver III

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

Thank you for letting us know. There were several reliability improvements in the July Gateway.

SidJay
Microsoft Employee
Microsoft Employee

As Miguel mentioned, these would be changes to the configuration of your firewall or proxy server.

SidJay
Microsoft Employee
Microsoft Employee

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

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

Where do I apply this configuration in the gateway application?

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.