Forum Discussion
Solved
Cannot connect Synapse serverless SQL pool to Power Bi
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). ...
Turns out our software was blocking the IP address. Thank you everyone for your help.
Hi AndyDDC , no this is not within a managed vnet.
Does the Synapse workspace have any IP firewall restrictions?
I currently have it set to allow all IP addresses. I also tried allowing the current IP address I was using and I got the same result.
Are you able to connect directly to the Serverless SQL Endpoint from within Power BI? This can be found in the Azure portal for the Synapse workspace.
E.G:
