Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
I am trying to connect my Synapse Serverless SQL pool to Power BI. Every time I try to connect it I get the same "error: 40 - Could not open a connection to SQL Server" message (seen below).
I have tried:
If you cannot connect via SSMS then the issue is not in Power BI.
I don't like the "Named Pipes" message - usually these connections should be done via TCP/IP.
How should I procede? Is there any other information I can give to find out more about this problem?
| User | Count |
|---|---|
| 16 | |
| 15 | |
| 13 | |
| 9 | |
| 8 |
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 34 | |
| 28 | |
| 27 |