Power BI Issue while connecting to Fabric Lakehouse SQL connection string

[rd10397]

It has been few weeks now that I am unable to connect to my Fabrics Lakhouse database from my dashboard.It used to work well previously but last month I started getting this error.

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

[Anonymous]

Hi @rd10397 ,

We are sorry to hear that you are having problems connecting to your Fabrics Lakehouse database. This error usually indicates a problem with the SQL Server instance or network configuration. You can refer to the following document, which provides steps to help you troubleshoot errors encountered when connecting to your SQL server instance, which are provided in order of problem from simple to complex.

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

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[rd10397]

I have Admin Role in the Workspace, I have doble check the Endpoint string yes have nearly tried it everyday for pas couple of weeks each time copying it from the Endpoint.
It is an organisation workspace so highly unlikely but not impossible that something might have changed is there anything that I could look for?

[Expiscornovus]

Hi @rd10397,

Have you tried using a different client/application to connect to your SQL endpoint just to rule out if it is related to the SQL endpoint or the application itself?

For example test with an test udl file or SQL Server Management Studio.

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/test-oledb-connectivity-u...

[rd10397]

Yes i have tried MSSQL and Azure Data Studio but get the same error.

Also something to note that the Connect works (Direct) but not the Connect to SQL endpoint, and I need the SQL endpoint to work for my dashboards.

[rd10397]

Yeah I have tried Azure Data Studio but its the same error also something to note that Onelake Data Hub connection works for just Connect (Direct) but not for Connect to SQL endpoint.

[Expiscornovus]

Hi @rd10397,

Just to double check, what kind of workspace role does your account have?

https://learn.microsoft.com/en-us/fabric/data-engineering/workspace-roles-lakehouse

Has something changed in the workspace role setup?

Additionaly, have you double checked the connection string in the SQL Endpoint settings of your Lakehouse?