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).

 

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)
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.

12 Replies

    • AndyDDC's avatar
      AndyDDC
      Most Valuable Professional
      2 years ago

      Does the Synapse workspace have any IP firewall restrictions?

      • noahcr_csap's avatar
        noahcr_csap
        Frequent Visitor
        2 years ago

        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.