Cannot connect Synapse serverless SQL pool to Power Bi

[noahcr_csap]

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:

1. Downloading .pbids file and opening that in Power BI
2. Selecting Get Data -> Azure Synapse Analytics SQL -> Database Login
3. Allowing outgoing traffic on ports 1433, 443, 80 on my pc
4. Starting over and creating new resource groups, storage accounts, synapse workspaces, etc..
5. Connecting to SSMS (I get the same "error: 40" code as seen in the image above)

[noahcr_csap]

Hi @AndyDDC , no this is not within a managed vnet.

[AndyDDC]

Does the Synapse workspace have any IP firewall restrictions?

[noahcr_csap]

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.

[AndyDDC]

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:

[noahcr_csap]

No, I was not able to connect using the Serverless SQL Endpoint, when I try this, I get the "Named pipes provider" error seen in the image on my original post

[AndyDDC]

Is there any way to try connecting from another network? 

[noahcr_csap]

I am working from home today and I was able to connect Power BI on my network. The work network must be blocking Synapse. I will bring this up to the IT department and give an update tomorrow.

[Anonymous]

Hi @noahcr_csap 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

[Anonymous]

Hi @noahcr_csap 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

[noahcr_csap · Accepted solution]

Turns out our software was blocking the IP address. Thank you everyone for your help.

[Anonymous]

Hi @noahcr_csap 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

[AndyDDC]

Hi @noahcr_csap is the Synapse Analytics workspace within a managed vnet?