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 nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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 | |
| 12 | |
| 11 | |
| 7 |
| User | Count |
|---|---|
| 44 | |
| 40 | |
| 33 | |
| 29 | |
| 21 |