This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register 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?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 12 | |
| 11 | |
| 9 | |
| 6 | |
| 5 |