Issue With Dataflow Gen2 Lakehouse Connection

Hi AmilaAkalanka ,

It appears that there may be network related issues or instance specific errors when trying to establish a connection to SQL Server. There are several things to be aware of:

• Intermittent Network Issues: Since the error occurs randomly, this may be due to an intermittent network issue. Ensure that your network connection is stable and uninterrupted.
• SQL Server Configuration: Verify that the SQL Server instance is configured to allow remote connections. This includes checking the SQL Server configuration settings and ensuring that the Named Pipes Provider is enabled.

Also, you can refer to below similiar solution:

Solved: Re: Couldn't refresh the entity because of an issu... - Microsoft Fabric Community

Best Regards,
Adamk Kong

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