I have a problem connecting Power BI to Lakehouse and Dataflow

[ashafaa]

I have a problem connecting Power BI to Lakehouse. When I connect to Lakehouse, an error like this appears:

Details: "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)"

Previously, I tried and could connect. But when I tried again, there was an error like that. I connect using SQL endpoint; there was an error that I couldn't use direct query, so I changed it to import.

But after that, I couldn't connect again using Lakehouse and dataflow; the same error always appears as above. What should I do?

[pvuppala]

Were you able to resolve this issue?  We're dealing with the same problem now where our VPN is probably restricting it but how to enable or bypass this?

Thanks in advance!

[Anonymous · Accepted solution]

Hi @ashafaa ,

You can try this to examine error:

• Ensure that the SQL endpoint you’re using is correctly configured and accessible.
• Verify that the instance name is correct and that SQL Server allows remote connections.

Below is the detail official link will help you:

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

Best Regards,

Xianda Tang

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