Forum Discussion

noahcr_csap's avatar
noahcr_csap
Frequent Visitor
2 years ago
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). ...
admin
Data Integration
data science
data warehouse
power bi
  • noahcr_csap's avatar
    noahcr_csap
    2 years ago

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

AndyDDC's avatar
AndyDDC
Most Valuable Professional
2 years ago

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's avatar
noahcr_csap
Frequent Visitor
2 years ago

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's avatar
    AndyDDC
    Most Valuable Professional
    2 years ago

    Is there any way to try connecting from another network? 

    • noahcr_csap's avatar
      noahcr_csap
      Frequent Visitor
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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