User Profile
noahcr_csap
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
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: 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)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: 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)
