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:
- Cleared the connection permissions in PowerBI
- Tried all three authentication methods
- Double checked the name of the SQL server
- Made sure we are able to connect to the server using Azure Data Studio.
- 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).
CodePudding user response：
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.
You can get this serverless endpoints directly from portal go to your synapse workspace resource >> overview >> here you can see Serverless SQL endpoint
just copy and paste this endpoint in powerBI where it asks for server name.
Enter the correct credentials of database like Username and Password
Connected successfully
Note My database does not contain any table that's why it is not showing any table