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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Rakesh_Kumar
Frequent Visitor

Unable to feed on-premises SQL-Server data into Lakehouse

We are trying to write on-prem sources to Lakehouse usign dataflow Gen2. Refresh is workign fine but when it tries to write down it's thowing below error. Anyone used on-prem source with Gen2 flow. FYI we are usign latest version of Gateway:


null 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 GatewayObjectId: *ID*

6 REPLIES 6
Rakesh_Kumar
Frequent Visitor

we checked on this and as per MS we have to open port 1433 (SQL server port) as Lakehouse is kind of SQL server.

Rakesh_Kumar
Frequent Visitor

@v-yangliu-msft  we are facing this issue in Power BI Servcie not in local (Power BI Desktop)

gauravjaini
Frequent Visitor

facing the same problem, did you find a solution?

@gauravjaini  not as of now. We are working on it. If you find a solution please post here. 

v-yangliu-msft
Community Support
Community Support

Hi  @Rakesh_Kumar ,

 

You can try the following:

Go to “File –> Options and Settings –> Options –> Data Load and delete cache files.
Go to File -> Options and  Settings -> Data Source settings. A window with all connections you have will appear. Select the SQL connection and at the bottom of the window click edit..Update the credentials.

Ensure that SSMS is installed on the same machine with Power BI Desktop.

 

Besides, please follow the instructions in the article below to troubleshoot this connection error.

A network-related or instance-specific error occurred - SQL Server | Microsoft Learn

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

It worked! Thank you so much!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors