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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.