Forum Discussion
Helper IUnable to connect to SQL server in Power bi desktop
Hi Shivakumarh ,
we need more information on this to help you further.can you follow below checklist and see if it works?
- Use Azure Synapse Analytics connector
Get Data > Azure > Azure Synapse Analytics - Enter correct server name
yourworkspace.sql.azuresynapse.net (for dedicated pool)
yourworkspace-ondemand.sql.azuresynapse.net (for serverless pool) - Choose authentication method
- Azure Active Directory - Organizational Account
- Basic (SQL username/password)
- Windows (if domain-joined) - Clear cached credentials
File > Options and settings > Data source settings > Clear Permissions - Test port connectivity.try below command in power shell.
Test-NetConnection -ComputerName yourworkspace.sql.azuresynapse.net -Port 1433- Test-NetConnection -ComputerName yourworkspace.sql.azuresynapse.net -Port 1433
- Ping server to verify DNS resolution try below command in command prompt.
ping yourworkspace.sql.azuresynapse.net- Check Synapse firewall settings
Enable public network access
Add your client IP to allowed list
Enable “Allow Azure services to access this workspace” - Try Azure Data Studio for connection test
- Download Azure Data Studio
- Use .pbids file to force correct connector
Create .pbids with server and connector settings - Verify workspace type and database context
- Check for private endpoint configuration
- Ensure you're on same VNet or using VPN
- Configure private DNS zone if needed - Inspect Conditional Access Policies
Confirm AAD policies aren’t blocking Power BI Desktop - Monitor Synapse logs for failed login attempts
Use Azure Monitor or Diagnostic Settings in Synapse workspace
Please give kudos or mark it as solution if it helps.
Thanks and Regards,
Praful
- Use Azure Synapse Analytics connector
Community SupportHi Shivakumarh,
Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.
Thank you.
Helper Iv-sgandrathi Still i am facing the same issue ,all the out bound connections are open i have checked with my Network team but still i am not able to create connection with Azure synampse SQL server in powerbi
- Praful_Potphode
Super User
Hi Shivakumarh ,
we need more information on this to help you further.can you follow below checklist and see if it works?
- Use Azure Synapse Analytics connector
Get Data > Azure > Azure Synapse Analytics - Enter correct server name
yourworkspace.sql.azuresynapse.net (for dedicated pool)
yourworkspace-ondemand.sql.azuresynapse.net (for serverless pool) - Choose authentication method
- Azure Active Directory - Organizational Account
- Basic (SQL username/password)
- Windows (if domain-joined) - Clear cached credentials
File > Options and settings > Data source settings > Clear Permissions - Test port connectivity.try below command in power shell.
Test-NetConnection -ComputerName yourworkspace.sql.azuresynapse.net -Port 1433- Test-NetConnection -ComputerName yourworkspace.sql.azuresynapse.net -Port 1433
- Ping server to verify DNS resolution try below command in command prompt.
ping yourworkspace.sql.azuresynapse.net- Check Synapse firewall settings
Enable public network access
Add your client IP to allowed list
Enable “Allow Azure services to access this workspace” - Try Azure Data Studio for connection test
- Download Azure Data Studio
- Use .pbids file to force correct connector
Create .pbids with server and connector settings - Verify workspace type and database context
- Check for private endpoint configuration
- Ensure you're on same VNet or using VPN
- Configure private DNS zone if needed - Inspect Conditional Access Policies
Confirm AAD policies aren’t blocking Power BI Desktop - Monitor Synapse logs for failed login attempts
Use Azure Monitor or Diagnostic Settings in Synapse workspace
Please give kudos or mark it as solution if it helps.
Thanks and Regards,
Praful
- Use Azure Synapse Analytics connector