CODEWITHSUNDEEP
azurepowerbipowerbi-desktopazure-synapsepowerbi-datasource
thereceptionist
thereceptionist

Reputation: 77

"Named Pipes Provider, error 40" when connecting to serverless SQL Pool via PowerBI Desktop

We are getting a "'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'" error when trying to connect to our serverless SQL Pool via PowerBI Desktop.

We have tried the following:

  1. Cleared the connection permissions in PowerBI
  2. Tried all three authentication methods
  3. Double checked the name of the SQL server
  4. Made sure we are able to connect to the server using Azure Data Studio.
  5. Tried using the Azure Synapse Analytics workspace (Beta) connector, which works. However using this connector we only access the lake database tables and not the views in the serverless SQL pool which we are interested in (we get an error pertaining to null values which seems to be a bug in the beta stage of this connector).

Upvotes: 0

Views: 1425

Answers (1)

Pratik Lad
Pratik Lad

Reputation: 8311

Posting it as answer to help for other community members.

I got similar error when I enter the endpoints which doesn't exist or wrong.

enter image description here

You can get this serverless endpoints directly from portal go to your synapse workspace resource >> overview >> here you can see Serverless SQL endpoint

enter image description here

just copy and paste this endpoint in powerBI where it asks for server name.

enter image description here

Enter the correct credentials of database like Username and Password

enter image description here

Connected successfully

enter image description here

Note My database does not contain any table that's why it is not showing any table

Upvotes: 1

Related Questions