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 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is 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?
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 14 | |
| 9 | |
| 9 | |
| 8 | |
| 6 |