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.

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

      • 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