The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?