topic Re: Cannot connect Synapse serverless SQL pool to Power Bi in Fabric platform

Cannot connect Synapse serverless SQL pool to Power Bi

noahcr_csap — Fri, 10 May 2024 16:19:45 GMT

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:

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

Re: Cannot connect Synapse serverless SQL pool to Power Bi

AndyDDC — Sat, 11 May 2024 14:06:23 GMT

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

Re: Cannot connect Synapse serverless SQL pool to Power Bi

noahcr_csap — Mon, 13 May 2024 11:11:03 GMT

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

Re: Cannot connect Synapse serverless SQL pool to Power Bi

AndyDDC — Mon, 13 May 2024 14:09:36 GMT

Does the Synapse workspace have any IP firewall restrictions?

Re: Cannot connect Synapse serverless SQL pool to Power Bi

noahcr_csap — Tue, 14 May 2024 13:10:32 GMT

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.

Re: Cannot connect Synapse serverless SQL pool to Power Bi

AndyDDC — Tue, 14 May 2024 14:54:29 GMT

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:

Re: Cannot connect Synapse serverless SQL pool to Power Bi

noahcr_csap — Tue, 14 May 2024 16:05:06 GMT

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

Re: Cannot connect Synapse serverless SQL pool to Power Bi

AndyDDC — Tue, 14 May 2024 17:03:15 GMT

Is there any way to try connecting from another network?

Re: Cannot connect Synapse serverless SQL pool to Power Bi

noahcr_csap — Thu, 16 May 2024 12:23:07 GMT

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.

Re: Cannot connect Synapse serverless SQL pool to Power Bi

Anonymous — Mon, 20 May 2024 15:47:35 GMT

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

Re: Cannot connect Synapse serverless SQL pool to Power Bi

Anonymous — Tue, 21 May 2024 16:37:19 GMT

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

Re: Cannot connect Synapse serverless SQL pool to Power Bi

noahcr_csap — Fri, 24 May 2024 11:10:41 GMT

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

Re: Cannot connect Synapse serverless SQL pool to Power Bi

Anonymous — Fri, 24 May 2024 11:12:23 GMT

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